'þ' Will shows '?' in table when I read it from text file
Posted by: Chintan Patel
Date: July 27, 2012 07:32AM

Hello,

I am facing problem with using 'þ' character.
I am reading this character from text file which was generated using "INTO OUTFILE..." now I am trying to insert data from this text file to database table using "LOAD DATA INFILE" After performing this steps In my database table data is not written properly it shows '?' everywhere where 'þ' is.

Can you give me tips what is wrong here ..............

Below is the my current settings for mysql variables
=====================================
'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'latin1'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'latin1'
'character_set_system', 'utf8'


'collation_connection', 'utf8_general_ci'
'collation_database', 'latin1_bin'
'collation_server', 'latin1_bin'
=====================================

Thanks
Chintan Patel

Options: ReplyQuote


Subject
Views
Written By
Posted
'þ' Will shows '?' in table when I read it from text file
3727
July 27, 2012 07:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.