lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]

No problem Ignacio. Thanks anyway.
I suppose the encode problem is resolved. I put the 'N' flag in front of the strings. My problem now is that the strings are beeing truncated from the SqlServer, just in the Fetch method of LuaSQL. When a field value has one accented char, it truncate the last one ('Flávia' comes like 'Fl??vi' - ?? are especial chars), if the text has two accented chars it has the last two chars cutted and so on...

2009/5/12 Ignacio Burgueño <>
Sorry, this occured to me just after hitting Send.

Forget what I said about forcing the encoding with ADO or recompiling LuaCOM.

"latin1 text" -> SqlServer -> ADO -> LuaCOM -> "utf-8 text"

you just need to convert this utf-8 text to latin1 before sending that to MySql. Again, ICU may be of help here.

Sorry for the noise

Marco Antonio Abreu
Analista de Sistemas