Using the latest .NET provider, I can connect to a
local FB server and create a table and run queries
that return properly sorted results using the
following connection string and commands:
// Server
string connectionString =
"Server=localhost;User=SYSDBA;CHARSET=WIN1254;COLLATE=PXW_TURK;Password=masterkey;Dialect=3;Database=zzz.fdb";
. . .
myCommand.CommandText = "CREATE TABLE PERSON3
(FIRSTNAME VARCHAR(50) COLLATE PXW_TURK, LASTNAME
VARCHAR(50) COLLATE PXW_TURK)";

But if I switch to the embedded FB using the following
connection string, I get and error in the CREATE TABLE
command indicating PXW_TURK is not valid:
// Embedded
string connectionString =
"ServerType=1;User=SYSDBA;Password=masterkey;Dialect=3;Database=zzzt.fdb";

BTW, I have the fbintl.dll in place. I have also tried
ISO8859_9 for collation and got an error indicating
it's not supported for the given character set (i.e.
WIN1254).

So my questions are:
- Does embedded FB support Turkish collation in any
way?
- Or is it something I'm missing in my
strings/commands?
- Where can I find which charset/collations are
supported in embedded FB?

I'd appreciate any help,

Cheers,
Cey




__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250