Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.150
  Buy Now
  HXTT Cobol 5.0.150
  HXTT DBF 7.1.151
  HXTT Excel 6.1.154
  HXTT Json 1.0.122
  HXTT Paradox 7.1.150
  HXTT PDF 2.0.150
  HXTT Text(CSV) 7.1.150
  HXTT Word 1.1.150
  HXTT XML 4.0.151
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

Accented characters with inserts using HXTT Access with ColdFusion?
Peter Riddle
2021-03-12 15:45:57.0
We are having trouble with SQL inserts that include accented characters (ex. ?? and ??) using HXTT Access and ColdFusion. We have tried using the ?charSet=UTF-8 and ?charSet=UTF-16 options with the connection string with success.

Do you have any suggestions for fixing this problem?
Re:Accented characters with inserts using HXTT Access with ColdFusion?
HXTT Support
2021-03-12 17:05:56.0
Maybe you're using an older MS Access database file format, which doesn't support UTF-8. You can try charSet= Cp895(Czech MS - DOS 895) or other value.

Cp037 USA, Canada (Bilingual, French), Netherlands, Portugal, Brazil, Australia
Cp273 IBM Austria, Germany
Cp277 IBM Denmark, Norway
Cp278 IBM Finland, Sweden
Cp280 IBM Italy
Cp284 IBM Catalan/Spain, Spanish Latin America
Cp285 IBM United Kingdom, Ireland
Cp297 IBM France
Cp420 IBM Arabic
Cp424 IBM Hebrew
Cp437 MS-DOS United States, Australia, New Zealand, South Africa
Cp500 EBCDIC 500V1
Cp737 PC Greek
Cp775 PC Baltic
Cp838 IBM Thailand extended SBCS
Cp850 MS-DOS Latin-1
Cp852 MS-DOS Latin-2
Cp855 IBM Cyrillic
Cp856 IBM Hebrew
Cp857 IBM Turkish
Cp858 Variant of Cp850 with Euro character
Cp860 MS-DOS Portuguese
Cp861 MS-DOS Icelandic
Cp862 PC Hebrew
Cp863 MS-DOS Canadian French
Cp864 PC Arabic
Cp865 MS-DOS Nordic
Cp866 MS-DOS Russian
Cp868 MS-DOS Pakistan
Cp869 IBM Modern Greek
Cp870 IBM Multilingual Latin-2
Cp871 IBM Iceland
Cp874 IBM Thai
Cp875 IBM Greek
Cp918 IBM Pakistan (Urdu)
Cp921 IBM Latvia, Lithuania (AIX, DOS)
Cp922 IBM Estonia (AIX, DOS)
Cp930 Japanese Katakana-Kanji mixed with 4370 UDC, superset of 5026
Cp933 Korean Mixed with 1880 UDC, superset of 5029
Cp935 Simplified Chinese Host mixed with 1880 UDC, superset of 5031
Cp937 Traditional Chinese Host miexed with 6204 UDC, superset of 5033
Cp939 Japanese Latin Kanji mixed with 4370 UDC, superset of 5035
Cp942 IBM OS/2 Japanese, superset of Cp932
Cp942C Variant of Cp942
Cp943 IBM OS/2 Japanese, superset of Cp932 and Shift-JIS
Cp943C Variant of Cp943
Cp948 OS/2 Chinese (Taiwan) superset of 938
Cp949 PC Korean
Cp949C Variant of Cp949
Cp950 PC Chinese (Hong Kong, Taiwan)
Cp964 AIX Chinese (Taiwan)
Cp970 AIX Korean
Cp1006 IBM AIX Pakistan (Urdu)
Cp1025 IBM Multilingual Cyrillic: Bulgaria, Bosnia, Herzegovinia, Macedonia (FYR)
Cp1026 IBM Latin-5, Turkey
Cp1046 IBM Arabic - Windows
Cp1097 IBM Iran (Farsi)/Persian
Cp1098 IBM Iran (Farsi)/Persian (PC)
Cp1112 IBM Latvia, Lithuania
Cp1122 IBM Estonia
Cp1123 IBM Ukraine
Cp1124 IBM AIX Ukraine
Cp1140 Variant of Cp037 with Euro character
Cp1141 Variant of Cp273 with Euro character
Cp1142 Variant of Cp277 with Euro character
Cp1143 Variant of Cp278 with Euro character
Cp1144 Variant of Cp280 with Euro character
Cp1145 Variant of Cp284 with Euro character
Cp1146 Variant of Cp285 with Euro character
Cp1147 Variant of Cp297 with Euro character
Cp1148 Variant of Cp500 with Euro character
Cp1149 Variant of Cp871 with Euro character
Cp1250 Windows Eastern European
Cp1251 Windows Cyrillic
Cp1253 Windows Greek
Cp1254 Windows Turkish
Cp1255 Windows Hebrew
Cp1256 Windows Arabic
Cp1257 Windows Baltic
Cp1258 Windows Vietnamese
Cp1381 IBM OS/2, DOS People's Republic of China (PRC)
Cp1383 IBM AIX People's Republic of China (PRC)
Cp33722 IBM-eucJP - Japanese (superset of 5050)
EUC_CN GB2312, EUC encoding, Simplified Chinese
EUC_JP JIS X 0201, 0208, 0212, EUC encoding, Japanese
EUC_KR KS C 5601, EUC encoding, Korean
EUC_TW CNS11643 (Plane 1-3), EUC encoding, Traditional Chinese
GBK GBK, Simplified Chinese
ISO2022CN ISO 2022 CN, Chinese (conversion to Unicode only)
ISO2022CN_CNS CNS 11643 in ISO 2022 CN form, Traditional Chinese (conversion from Unicode only)
ISO2022CN_GB GB 2312 in ISO 2022 CN form, Simplified Chinese (conversion from Unicode only)
ISO2022JP JIS X 0201, 0208 in ISO 2022 form, Japanese
ISO2022KR ISO 2022 KR, Korean
ISO8859_2 ISO 8859-2, Latin alphabet No. 2
ISO8859_3 ISO 8859-3, Latin alphabet No. 3
ISO8859_4 ISO 8859-4, Latin alphabet No. 4
ISO8859_5 ISO 8859-5, Latin/Cyrillic alphabet
ISO8859_6 ISO 8859-6, Latin/Arabic alphabet
ISO8859_7 ISO 8859-7, Latin/Greek alphabet
ISO8859_8 ISO 8859-8, Latin/Hebrew alphabet
ISO8859_9 ISO 8859-9, Latin alphabet No. 5
MS874 Windows Thai
MS932 Windows Japanese
MS936 Windows Simplified Chinese
MS949 Windows Korean
MS950 Windows Traditional Chinese

Re:Re:Accented characters with inserts using HXTT Access with ColdFusion?
Pete Riddle
2021-03-15 04:27:40.0
Thank you!

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap