|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Howto get UNICODE_FSS data from Table.
Dear all,
Situation: Firebird 1.5.1 Database with 1. default character set : ISO8859-1 JCA-JDBC 1.5.3 Driver CREATE DOMAIN "CHN_NAME" AS VARCHAR(50) CHARACTER SET UNICODE_FSS DEFAULT '' NOT NULL; CREATE DOMAIN "ENG_NAME" AS VARCHAR(100) DEFAULT '' NOT NULL; CREATE TABLE "SYSUSER" ( "ENG_NAME" ENG_NAME, "CHN_NAME" CHN_NAME ); Question: When i use the following query to get the details from the table though the jdbc drive then an error is occured. Query: SELECT * FROM SYSUER where CHN_NAME like '%我%' Error: GDS Exception. 335544321. arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets Any one can help me?? Thank you very much. Jeff 2004-10-11 |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Howto get UNICODE_FSS data from Table. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|