|
From: SourceForge.net <no...@so...> - 2005-08-10 13:14:26
|
Field-test item #1255347, was opened at 2005-08-10 02:50 Message generated for change (Settings changed) made by dimitr You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1255347&group_id=9028 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Charsets/Collations Group: None Status: Open Resolution: None Priority: 5 Submitted By: Minoru Yoshida (timeful) >Assigned to: Adriano dos Santos Fernandes (asfernandes) Summary: Character transliterate error . Initial Comment: I tested the transliterate character of some character sets which japanese will use. The target character sets are SJIS_0208, UTF8, UNICODE_FSS, and EUCJ_0208 by SJIS_0208 connection. I found the unmatch case in comparison with V1.5.2. The following EUCJ_0208 characters between SJIS_0208 character sets. - Single-byte: 0xA1-DF(63 chars) - Multi-byte: 0x8140-EFFC,0x989F-EFFC,0xFA40-FC4B(2,343 chars -JIS X0208 Not assign chars) The unmatch case error is: arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets ---------- FB: V2.0.0.11252(Alpha 3) win32 Superserver. OS:WindowsXP SP1. Middleware:IBObjects 4.5B. ---------- The following is the contents of a testing. 1. Create testing table(e.g. UTF8) : - CREATE TABLE "TestTable" ( ,"Keycode" VARCHAR(4) NOT NULL ,"Teststr" VARCHAR(1) CHARACTER SET UTF8 , CONSTRAINT "PK" PRIMARY KEY ("Keycode")); 2.Insert testing SQL: - INSERT INTO TestTable ( Keycode, Teststr ) VALUES( 'Key code' ,'Original char'); - The test character number of cases is 11,443. e.g. Case Sjis Character 'A' : Key code is '0041',Original char is 'A'. 3. Compare testing SQL: - SELECT Teststr FROM TestTable WHERE Keycode = 'Key code' ; - Comparison of the value of Teststr and Original char . ---------- Result document: http://www.timeful.co.jp/fbmap/FB0003E.htm All test documents:(sorry, japanese only) http://www.timeful.co.jp/fbmap/index.htm ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1255347&group_id=9028 |