ODBC danish windows inserting wrong boolean.

--_c337051e-f9c0-4d79-81ec-2dea230a30c6_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


I just reinstalled my pc its running danish win xp as it was before.

My application is in VB6 it connects to mysql on the same pc using myodbc. =
All this worked fine before the new install.

now im getting the following error:

SQL MSG:[MYDB.EXECUTE_CMD] (-2147217900) [MySQL][ODBC 3.51
Driver][mysqld-5.0.45-community-nt]Unknown column 'Falsk' in 'field
list'
SQL ERROR:insert into que
(action,commands,que_id,sandbox,comment,requested_by,submite d) values
('NPC','\"Count\"
Ungula',18285,Falsk,'NPC_requests:18285','Laurlybot',now())

If i print out the variable in visual basic it says its "false" yet
when it tryst to insert it into the database it uses the word "falsk"=20
which in danish is "false" how do i get it to use the English spelling? T=
his is probably has to do with why i cant insert dates into the database ei=
ther as it trys to use the danish format (DD-MM-YYYY) for those by default =
instead of mysqls default of YYYY-MM-DD.My application is rather large and =
i would rather not have to change all the boolean variables to something li=
ke tinyint storing 1 and 0.Thanks Linda
____________________________________________________________ _____
Make every IM count. Download Windows Live Messenger and join the i=92m Ini=
tiative now. It=92s free.=A0
http://im.live.com/messenger/im/home/?source=3DTAGWL_June07=

--_c337051e-f9c0-4d79-81ec-2dea230a30c6_--