Roger, Monday, November 18, 2002, 9:56:05 PM, you wrote: RW> I'm running MySQL 323 under Win 2000 SP2. I'm using Apache 2.0.43 and Cold Fusion MX. I have this Cold Fusion RW> application that has worked well under MS-Access but when i ported it to MySQL the Swedish characters ÅÖÄ åöä RW> in the Memo-fields just won't show! I'm getting '???' instead of a readable character. RW> When i alter my.ini (language=S:\MySQL\share\swedish) in the WinMySQLAdmin the server goes red. When i comment RW> the line the server starts again. RW> But: when looking under the tab 'Variables' in theWinMySQLAdmin it tells me that the character set "Latin1" RW> is in use. This DAMN thing SHOULD work, but no way... RW> I'm not (as far as i understand) using MyODBC. When i created the DataSource in MX i picked the driver RW> 'MySQL' from MX, and this was before i installed MyODBC, so i think the one i'm using was installed with Cold Fusion. RW> I've spent hours reading the manual, but i can't figure this out by myself. Is this a MySQL-error or is it a Cold Fusion MX- RW> error?? RW> I anyone can give me some light on this matter i'd really appreciate it.
First of all "language" is used for non-english error message, for setting up different then latin1 character set use default-character-set=# option. The second - MySQL server stores data as you inserted them, so check you locale settings. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
