# Import unicode characters **URL:** \ **Category:** Rails\ **Created:** [May 29, 2009, 11:29am UTC](https://www.ruby-forum.com/t/import-unicode-characters/169097 "2009-05-29T11:29:31Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![lecielbleu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/b487fb/32.png) [@lecielbleu](https://www.ruby-forum.com/u/lecielbleu)\ **Post date:** [May 29, 2009, 11:29am UTC](https://www.ruby-forum.com/t/import-unicode-characters/169097/1 "2009-05-29T11:29:31Z")
Hi , i have a problem while importing unicode characters (üºçöetc…). i have scaffold categories model then i try create new categorie using CRUD scenario so it worked , but when i use csv\_import controller , characters dont seems right. how can i solve this problem ---
**Author:** ![lecielbleu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/b487fb/32.png) [@lecielbleu](https://www.ruby-forum.com/u/lecielbleu)\ **Post date:** [May 29, 2009, 11:46am UTC](https://www.ruby-forum.com/t/import-unicode-characters/169097/2 "2009-05-29T11:46:37Z")
I’ve discovered the same thing as Peter, although I’m using different tools (Upscene’s Database Workbench Pro 2.8.10) to import the data from both MDB and Firebird tables, which both handle the unicode (DBCS) character set acceptably well. Having said that, I’ve also tried command-line importing from native and delimited text versions of my source data, and I get exactly the same errors as I see in DBW. e.g. : Incorrect string value: ‘Agnetha F\xE4ltskog’ for column ‘artistname’ at row 1 I’m using MySQL V5.0.45 x64. I’ve tried every different combination of character set for the columns in the destination MySQL table, and neither single nor double-byte characters seem to be imported properly. I’ve also tried using different table types (InnoDB and MySAM) to see if that makes any difference. It doesn’t appear to (i.e. I get the same errors at the same point in the imported data). I do understand that there are some limitations in using unicode (or unicode-like) character sets, but I’m banging my brains out trying to not have to hand-edit or perform on-the-fly mappings of a couple of characters in a couple of columns in ~1200 records of a 7,000 record source table to import them into MySQL. It’s a bit frustrating that MySQL doesn’t seem to handle the same characters that Access and Firebird 2.0.1 deal with without fuss (once the correct character set is configured, of course!). There remains the other major problem of handling of non-unicode NLS mappings (Greek, Cyrillic, Slavic, etc), but I’ll deal with that on a record-by-record basis at a later date. But to import about 1000 records containing various unicode characters is my main focus. Any suggestions? I’m happy to post examples, error messages, character values, whatever it takes! I’d really like to solve this problem, or at least understand why the mappings aren’t correct. with regards, Brad W. ([Caverta ](http://www.netpharmaworld.com/purchase/caverta.asp)|[kamagra](http://www.trustpharma.com/purchase/kamagra.asp)) ---
**Author:** ![lecielbleu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/b487fb/32.png) [@lecielbleu](https://www.ruby-forum.com/u/lecielbleu)\ **Post date:** [May 29, 2009, 11:47am UTC](https://www.ruby-forum.com/t/import-unicode-characters/169097/3 "2009-05-29T11:47:57Z")
I’ve discovered the same thing as Peter, although I’m using different tools (Upscene’s Database Workbench Pro 2.8.10) to import the data from both MDB and Firebird tables, which both handle the unicode (DBCS) character set acceptably well. Having said that, I’ve also tried command-line importing from native and delimited text versions of my source data, and I get exactly the same errors as I see in DBW. e.g. : Incorrect string value: ‘Agnetha F\xE4ltskog’ for column ‘artistname’ at row 1 I’m using MySQL V5.0.45 x64. I’ve tried every different combination of character set for the columns in the destination MySQL table, and neither single nor double-byte characters seem to be imported properly. I’ve also tried using different table types (InnoDB and MySAM) to see if that makes any difference. It doesn’t appear to (i.e. I get the same errors at the same point in the imported data). I do understand that there are some limitations in using unicode (or unicode-like) character sets, but I’m banging my brains out trying to not have to hand-edit or perform on-the-fly mappings of a couple of characters in a couple of columns in ~1200 records of a 7,000 record source table to import them into MySQL. It’s a bit frustrating that MySQL doesn’t seem to handle the same characters that Access and Firebird 2.0.1 deal with without fuss (once the correct character set is configured, of course!). There remains the other major problem of handling of non-unicode NLS mappings (Greek, Cyrillic, Slavic, etc), but I’ll deal with that on a record-by-record basis at a later date. But to import about 1000 records containing various unicode characters is my main focus. Any suggestions? I’m happy to post examples, error messages, character values, whatever it takes! I’d really like to solve this problem, or at least understand why the mappings aren’t correct. with regards, Brad W. > **[Dolar77: Link Alternatif Dolar77 | Login Dolar 77 Slot Online Resmi](https://netpharmaworld.com/)** > > Dolar77 adalah situs judi slot online link alternatif resmi Dolar 77 gacor gampang menang dan login daftar Dolar77 RTP Live Slot terpercaya. [http://www.trustpharma.com/blog](http://www.trustpharma.com/blog) ---
**Author:** ![lecielbleu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/b487fb/32.png) [@lecielbleu](https://www.ruby-forum.com/u/lecielbleu)\ **Post date:** [May 29, 2009, 2:30pm UTC](https://www.ruby-forum.com/t/import-unicode-characters/169097/4 "2009-05-29T14:30:15Z")
Thanks for all , i have solved problem , it was only text-editor options , i changed scite standarts (encoding=utf-8) and it’s worked 🙂 On May 29, 12:47 pm, Brad W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)