Egor Egorov wrote:
Roger,ColdFusion MX uses and older version of the MM.MySQL JDBC driver. Because of this, you will need to add 'useUnicode=true' and 'characterEncoding=ISO8859_1' (or whatever is the appropriate ISO encoding name for your character set -- 'swedish' in MySQL maps to 'ISO8859_1' I believe) to your connection properties. I haven't seen ColdFusion MX outside of a beta test, but I believe somewhere buried in the database connection form, there is a place to put in custom 'properties'.
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.
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ 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
