vijdev Posted June 20, 2010 Share Posted June 20, 2010 hi, how do i load something like Aabyhöj Aafsadîq Aakjær Abadín Abádszalók Ábær into INNODB? Quote Link to comment Share on other sites More sharing options...
Mchl Posted June 20, 2010 Share Posted June 20, 2010 Just like any other text. You just have to make sure you have proper encodings set up for table, column, connection and application. Quote Link to comment Share on other sites More sharing options...
vijdev Posted June 21, 2010 Author Share Posted June 21, 2010 exactly - so my Q is what is "proper encodings" and setup to load foreign chars? and are these settings generic..or specific to certain languages only? Quote Link to comment Share on other sites More sharing options...
Mchl Posted June 21, 2010 Share Posted June 21, 2010 In most cases you'll want to set up everything to unicode/utf8 Quote Link to comment Share on other sites More sharing options...
ignace Posted June 21, 2010 Share Posted June 21, 2010 Here's an article that explains encoding and issues: http://www.phpwact.org/php/i18n/charsets. If anyone has some better resources when it comes to encoding and stuff, please share. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 22, 2010 Share Posted June 22, 2010 Actually, there's a sticky somewhere -- maybe in the child board. Quote Link to comment Share on other sites More sharing options...
vijdev Posted August 15, 2010 Author Share Posted August 15, 2010 i still am looking for an answer. am trying a direct CSV import, and in UTF-8... anyone? should i use latin-1...am gona be trying this...in the meanwhile.. 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.