Current location: Hot Scripts Forums » Other Discussions » Database » problem when importing

problem when importing

Reply
  #1 (permalink)  
Old 06-21-09, 05:43 AM
john_zakaria john_zakaria is offline
Newbie Coder
 
Join Date: Nov 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
problem when importing

i am importing a csv file that contains a unicode data using php my admin...

i import it but it is not displayed as uniocde for example :

al-Lujū΄ ilá Allāh : is shown as al-Luju?? il? Alla?h :


i tried to set the character

mysql_query("set names utf8");

note that when inserting al-Lujū΄ ilá Allāh from php my admin it is shown correctly but when importing it from a file named: 2fields.csv
(a csv file) it is not shown as unicode data
it is shown as al-Luju?? il? Alla?h

can anyone help me to import unicode csv file??

thnx alot
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 06-22-09, 12:45 AM
=OTS=G-Man =OTS=G-Man is offline
Newbie Coder
 
Join Date: Jun 2009
Posts: 55
Thanks: 0
Thanked 0 Times in 0 Posts
are you importing from phpMyAdmin or right from mysql?

because i know php does not officially support Unicode yet(well last time I checked about a year ago)

so I would suggest using something like a mysql front end like SQLyog (don't know if it support importing or not, but I use it for management of my server) or something like it.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #3 (permalink)  
Old 06-22-09, 01:42 AM
john_zakaria john_zakaria is offline
Newbie Coder
 
Join Date: Nov 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by =OTS=G-Man View Post
are you importing from phpMyAdmin or right from mysql?

because i know php does not officially support Unicode yet(well last time I checked about a year ago)

so I would suggest using something like a mysql front end like SQLyog (don't know if it support importing or not, but I use it for management of my server) or something like it.
i'm using php my admin and i tried to insert romanized data and it enters very well.. but when importing it from a csv file .. it did not enter as romanized.

i dont know how to fix this problem
but i really need it
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
login, roles problem dbrook007 ASP.NET 10 11-10-06 04:42 PM
Form Display Problem neevrap02 Visual Basic 1 09-05-06 06:18 AM
SQL Importing problem (from php) gigafare PHP 1 03-16-06 10:23 AM
Count problem kasic ASP.NET 1 10-20-04 01:23 AM
Asp and Microsoft Access 2002 problem gop373 ASP 2 10-06-04 10:13 AM


All times are GMT -5. The time now is 11:17 PM.
vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.