hoho Posted May 24, 2013 Report Share Posted May 24, 2013 Man ir tabulas dump windows-1257 kodējumā, vajag pārnest uz citu datu bāzi, utf-8 kodejumā. Kā var parkonvertēt tabulas dumpu uz utf-8? Rediģēt failu nevaru, pārāk liels apjoms, vajag kaut kā ar dump export/import. Paldies. Quote Link to comment Share on other sites More sharing options...
daGrevis Posted May 24, 2013 Report Share Posted May 24, 2013 http://stackoverflow.com/a/2311863/458610 Quote Link to comment Share on other sites More sharing options...
hoho Posted May 24, 2013 Author Report Share Posted May 24, 2013 Es mēģinu sekojoši: 1. mainu kodējumu: iconv -f latin1 -t UTF-8 education.sql > education1.sql 2. mainu latin1 uz utf-8: sed -e 's/latin1/utf8/g' education.sql > education1.sql 3. importēju: mysql -u -p --default-character-set=utf8 dbname < education1.sql bet diemžēl rezultātā vienalga ir problēma ir kodējumu, piem. Rīga ir Rîga. Vai ir idejas kas ir nepareizi? Quote Link to comment Share on other sites More sharing options...
marrtins Posted May 24, 2013 Report Share Posted May 24, 2013 Pirmam variantam būtu jāstrādā. iconv -f CP1257 Kādā veidā importē datus atpakaļ? Quote Link to comment Share on other sites More sharing options...
hoho Posted May 25, 2013 Author Report Share Posted May 25, 2013 Kad mēģinu pirmo komandu iconv -f latin1 -t UTF-8 education.sql > education1.sql uz iconv -f CP1257 -t UTF-8 education.sql > education1.sql dabūju kļūdu: iconv: illegal input sequence at position 2423 Importēju no konsoles : mysql -u -p --default-character-set=utf8 dbname < education1.sql Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.