Imporing Euro sign

Muiter · #1 (**permalink**) 12-31-08, 06:33

I have script where people can inser values strarting with a € sign. This works very good. Now I've import thry phpMyadmin a lot of values and all € are changed to ?
What went wrong and how can I change this? I think the best way is to write a script in php with a certain sql query but how shouls this query look?

gvee · #2 (**permalink**) 12-31-08, 07:16

What is the datatype of the column you are using?

Muiter · #3 (**permalink**) 12-31-08, 07:53

Quote:

Originally Posted by georgev

What is the datatype of the column you are using?

I'm using latin1 and I've tried utf8.

gvee · #4 (**permalink**) 12-31-08, 08:04

try switching to nvarchar

healdem · #5 (**permalink**) 12-31-08, 08:06

is this a web application or a traditional application
if its a web application you may be better off converting the euro symbol to its web safe code €

its possible that PHPMyAdmin, or your copy, is only ascii aware and not fully international

what is making you import through PHPMyAdmin... there may be another route (one that I've used in the past is to upload a flat file and then import using a PHP script)

Muiter · #6 (**permalink**) 01-01-09, 14:21

Quote:

Originally Posted by georgev

try switching to nvarchar

I can't find that option

Quote:

Originally Posted by healdem

what is making you import through PHPMyAdmin... there may be another route (one that I've used in the past is to upload a flat file and then import using a PHP script)

Just a one time story so that's why I'm using MySQL.

I changed all my values for now with:

Code:

UPDATE factuurnummers SET bedrag_excl = REPLACE(bedrag_excl, '?', '€')

Internet Services

Web Development

Digital Marketing

Consumer Tech