Hi Jorge,
If the vesion of mySQL that you use supports Unicode (...from googling, it
seems that 4.1 does), you shouldn't need to do anything with those symbols.
Your original post had a pretty weird assortment of symbols (quite a few
from Latin Extended A, Latin Extended B, Greek).
Checking character by character is terribly slow. If you need to replace
them with something, it would be faster to use Find/Replace, especially if
the docs are large.
You can use a wildcard search to look for characters in a certain code range
by searching for [x-y], where you can copy any Unicode character into the
Find dialog for x and y.
Or you can type the hex code, and use Alt+X (in the English version,
ToggleCharacterCode) to toggle the code into the character.
Say a search for [A-?] (Unicode U+0100 - U+03F3) should find all characters
in the code blocks mentioned above.
Once you have found such a character that needs to be converted with the
wildcard search, you can determine the code (AscW) and replace it in the
whole doc... Rinse and repeat until no more problematic characters are
found.
Characters from Latin-1 (¹¶µ®...) should not be a problem, they are probably
covered by the character set in mySQL anyway.
Regards,
Klaus
> Thanks a lot for your answers,
> Then I guess that the best solution would be to replace the symbols by the
[quoted text clipped - 40 lines]
>> >
>> > Jorge
Klaus Linke - 01 Nov 2007 04:43 GMT
> Say a search for [A-?] (Unicode U+0100 - U+03F3)
Say a search for [Ā-ϳ] ...
(forgot how to send Unicode: Mime, Quoted Printable)
Klaus