Due to enormous amounts of spam, the forum has been set to read-only mode.



Reply to topic  [ 5 posts ] 
CATraxx + PHP grabber 
Author Message
User avatar

Joined: Mon Aug 08, 2005 10:15 am
Posts: 81
Location: Naples, ITALY
Post CATraxx + PHP grabber

hi,
I have wrote a basic php script that grab content from a web page and put into CATraxx database.
The content that I grab is related to artist info.
But I have a problem when try to insert into database a text string like "Wrocław" the result is "WrocÅ‚aw".
This seems a problem related to character encoding.
Anyone have a similar experience?
I use php ODBC functions for the connection to database.
Thanks in advance.

_________________
If you think you are too old to rock 'n roll, then you are.


Wed Apr 04, 2012 8:32 am
Profile WWW
User avatar

Joined: Sat Nov 22, 2003 7:47 pm
Posts: 2547
Location: Denmark
Post Re: CATraxx + PHP grabber

You should convert the string to Unicode before inserting into the CATraxx database.

_________________
Kind regards
Thomas Hamstrup

HAP Software (http://www.hamstrup.dk)

Using Windows 8 PRO 64-bit and CATraxx 9.44


Fri Apr 06, 2012 6:24 pm
Profile WWW
User avatar

Joined: Mon Aug 08, 2005 10:15 am
Posts: 81
Location: Naples, ITALY
Post Re: CATraxx + PHP grabber

hamsen wrote:
You should convert the string to Unicode before inserting into the CATraxx database.


I have tried but nothing seems working.
You can suggest me the correct way to do this? thanks.

_________________
If you think you are too old to rock 'n roll, then you are.


Mon Apr 09, 2012 7:26 pm
Profile WWW
User avatar

Joined: Mon Aug 08, 2005 10:15 am
Posts: 81
Location: Naples, ITALY
Post Re: CATraxx + PHP grabber

Hi!
If someone is interested I have solved using ADOdb.

_________________
If you think you are too old to rock 'n roll, then you are.


Tue May 22, 2012 3:05 pm
Profile WWW
Site Admin
User avatar

Joined: Fri Nov 22, 2002 3:52 pm
Posts: 13748
Post Re: CATraxx + PHP grabber

mace wrote:
hamsen wrote:
You should convert the string to Unicode before inserting into the CATraxx database.


I have tried but nothing seems working.
You can suggest me the correct way to do this? thanks.

Have you tried to convert the string with "utf8_encode" before saving it to the database?

_________________
Fredrik Nordbakke
www.fnprg.com


Wed May 23, 2012 9:29 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 5 posts ] 

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.