Ben, Turkce için database'i WIN1254 yarattim.
Tablolari da yaratirken asagidaki gibi her fielda (numeric olmayanlara) CHARSET verdim(asagida örnek var), COLLATE seçenegini PXW_TURK olarak set ettim(sort problemini ortadan kaldirmak için)

lc_ctype=WIN1254 diyerek connection stringi olusturdum. Su an hiç bir problem yasamiyorum.

yanliz characterseti(hem database hem tablo) sonradan degistirdigimde problem yasiyorum, characterset degistirmek için sifirdan database yaratman gerekiyor galiba.


CREATE TABLE MENU (
MENU_ID INTEGER,
ITEM_ORDER INTEGER,
NODE_ID INTEGER,
PARENT_NODE_ID INTEGER,
ITEM_NAME VARCHAR (765) CHARACTER SET WIN1254 COLLATE PXW_TURK,
ITEM_DESCRIPTION VARCHAR (765) CHARACTER SET WIN1254 COLLATE PXW_TURK,
LINK VARCHAR (765) CHARACTER SET WIN1254 COLLATE PXW_TURK,
FRAME VARCHAR (48) CHARACTER SET WIN1254 COLLATE PXW_TURK,
IMAGE VARCHAR (765) CHARACTER SET WIN1254 COLLATE PXW_TURK);

----- Original Message -----
From: Haci Yigit
To: Firebird-Java@yahoogroups.com
Sent: Saturday, May 22, 2004 9:23 AM
Subject: [Firebird-Java] Turkish Character Problem


"C:\\Program Files\\Firebird\\Firebird_1_5\\bin\\HTTPLOGS.GDB?
lc_ctype=ISO8859_9"

Then when i run JSP page it gives this error message, please tell me
what can do ?

org.apache.jasper.JasperException: GDS Exception. 335544321.
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets

Thanks alot.




Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/

b.. To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.670 / Virus Database: 432 - Release Date: 27/04/2004

[Non-text portions of this message have been removed]