nimdraal

Hi I have basically two quesitons. 1: For decimal coordinates. normaly like 56.230943 but in extreme cases -102.1323123 or the previous number but positive. I am currently using double (11, 8 Is that the best option? 2: When I store coordinates in another format. Like this "58°1′57.35″N". How shall I do to get that exact string from the form at the webpage to get stored in the right format in the database? I have read about spatial extensions... But I get the impression that I should learn to walk before I start to run... right?

Apparently when I replace the field with 'NULL' and then reenter it the mystic question mark is gone. Updating apparently just updates the value that I see in the GUI. I am guessing that this is due to that something went wrong with the import of the file since there are special characters and a charset with Swedish characters in it. Thanks for the help.

I used the GUI of phpmyadmin to erase and then input the data again. Now I tried both update query and delete and insert but I still get that pesky question mark... I entered the values manualy to be sure that there wasn't an issue with copy and paste. This has happened on a couple of other places in this particular column, say 50% of the values I enter after the import of the csv file has a ? infront of the values.

That is a good tip kicken. However I am not sure on how to do that correct. If I do a command in the sql command prompt like this: SELECT HEX(name of column) FROM `namn of database` WHERE relid LIKE 3 // relid 3 is that particular row... Would that give me the correct output?

Yes. I checked the csv file and That particular field was blank when I imported the file. This value that ends up having the question mark infro t was added manually after the import. I did this through phpmyadmin. I tried deleting the value and adding it again without any result. I also tried to export the current sql to a csv file to see if there was something infront of the value, but there wasnt anything there. When I did the import I had another column with coordinates in degrees with the degree character. These values was corrupt after the import, only the first two digits was left... Could this have made the whole db corrupt in some way?

I imported a csv file to the sql database, hence the varchars everywhere. Since I am quite unexperienced to sql and php I wanted to get my homepage up and running and then deal with trimming the database and dealing with validations and stuff like that. Would the VARCHAR crop the data? I suspect I should use float instead, but still... does it explain why some numbers come out right on the homepage and some dont with the same sql querys? The particular value has an exclamation mark (?) infront of it when I use a query and then echo the value to my homepage. When I look at the value in the database it looks fine. And with the same query most of the rows output just fine.

Also: Server: Unix xocket Software: MySQL Version: 5.1.70-cll MySQL Community Server Protokoll 10 Webbserver cpsrvd 11.38.1.6 client version libmysql - 5.0.96

Hi. Don't know where to put this, but I am guessing that I have a problem with my sql table. I have a column who has the setup varchar(10), utf8_general_ci At one row I have the value 58.0326, when I do a query and echo the data it outputs exactly "58.0326". But in another row I have the value 63.44528 but when I echo that it comes out "?63.44528" on the webpage. I have tried to search and google for an answer to this problem but havent been able to find anything. Hope one of you php freaks can help me.