Hi! I'm using a database creation script file that is in UTF8 encoding, and using "SET NAMES UTF8" it executes well with isql.exe. I didn't want to ship isql.exe with my product, so I switched to using Isql.FbBatchExecution. The script executes, but the string "fejlesztő", when inserted into an UTF8 encoded column, becomes "fejleszto". I read the script to a string as UTF8, it reads correctly and "fejlesztő" remains "fejlesztő" in the string (but it isn't UTF8 any more). I used UTF8 in the connection string and the default charset of the database is ISO8859_1. What connection character set and method should I use, to execute SQL statements contained in C# strings to preserve non-ASCII characters?
Gabor Torok ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
