Hi to all,
I have a big problem!
I have an Lotus server on Linux Debian, and MySql is on the server too. I run an Agent on the server that exports data to MySql, the problem is that I dont get the croatian characters exported right. When i run an INSERT command from phpMyAdmin on the MySql(utf-8) db the characters are shown correctly but when I do it from Lotus 3 of 5 are exported incorrectly.
As I said before the agent is running on the server and I dont know where to change the character set or codepage or whatever needs to be changed.
Thank you in advance
Branimir
Subject: URGENT!!! Lotus character export
Hi Brane, without examining the actual code, it will be very difficult to point out the solution. However, I am assuming that MySQL has been corectly set up for UTF-8 (BTW, which version of MySQL are you using?)
However, there are a couple of gotcha’s that you need to be aware of
(a) Make sure that your Driver that handles Notes/RDBMS connection is UTF-8 aware (usually they are - never hurts to check)
(b) Escape your strings before passing them along to
e.g. @urlencode(“UTF-8”;mystring)
you might want to evaluate this statement and pass the resultant values like so:
dim tmpVar as variant
dim tmpStr as String
tmpvar = evaluate(…the urlencode call …)
tmpStr = Cstr(tmpVar(0))
Subject: RE: URGENT!!! Lotus character export
Hi I have fixed the problem.
I Before i did anything I executed the query:
SET CHARACTERSET SET ‘cp1250’
Now it works fine
THNX