Databases :: MySql :: Foriegn characters in mysql |
|||
By: Squibi  |
Date: 28/03/2003 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
Afternoon all! My mysql table has (varchar(150)) that contains millions of variations of strings. Some of the strings look like this: "Â÷ÀÌÄÚÇÁ½ºÅ°-" How do I get rid of this stuff? When i select for left(fieldname,1)='a' it returns the above foriegn characters. They are not the same pattern every time... Thanks... |
|||
| By: VGR | Date: 28/03/2003 08:18:00 | |
Type : Comment |
| ??? |
|||
| By: Squibi | Date: 28/03/2003 08:29:00 | |
Type : Comment |
| Sorry - they looked totally different when I pasted them in there... |
|||
| By: VGR | Date: 28/03/2003 09:00:00 | |
Type : Comment |
| are they accentuated characters from other charsets ? are they MIME-encoded codes like E0 ? |
|||
| By: Squibi | Date: 28/03/2003 09:15:00 | |
Type : Comment |
| Why yes - they are... Thanks for putting a name to that... Any Ideas? |
|||
| By: VGR | Date: 28/03/2003 09:33:00 | |
Type : Answer |
| yes : it's normal. Those strings are coming from where ? Internet ? Posted by people ? If it's the E0 and such the problem, you can write a "moulinette" (datapump) to transform them to ANSI accentuated characters If ever you show me some more data (you can send it to my email address), along with the table description and expected result, I may work something out for you. |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
