mysql charset problem

[phpprogrammer]

Dear Friends,

I am getting a problem

My query is :

$sqlQuery_city_name="insert into ".$citytablename."(city_name,city_alias,countryID,nr_hotels)
values('".addslashes($xmlcityname)."','".addslashes($xmlcityaliasname)."','".$countryid."','".$nrhotels."')";

If I am inserting the values into database, junk values are inserting .

The query generated by the above code is as follows

insert into atlas_location(city_name,city_alias,countryID,nr_hotels) values('Benešov','Benešov','55','1')

if I am writing a code like

$query="insert into atlas_location(city_name,city_alias,countryID,nr_hotels) values('Benešov','Benešov','55','1')";

It is inserting the data correctly

I observed that the problem is If I am sending the values by using a php variable junk characters are inserting into database

anyone help me how to sort this

regards,
bvsureshbabu

[sfullman]

Should probably go in the coding forum.

If you're getting the data from a form post and you have majic quotes turned on, you DON'T want to use addslashes(). Is a \ the character you're referring to? If you're getting the data from an array, an existing db table, or some other place then yes use addslashes()

I suggest you place echo in front of your declaration of your sql string and take a look at it while in process.

Is š a standard ascii character? I assume it is.

Sam