'þ' Will shows '?' in table when I read it from text file
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
Subject
Views
Written By
Posted
'þ' Will shows '?' in table when I read it from text file
3893
July 27, 2012 07:32AM
1953
July 30, 2012 08:01PM
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.