Error with decimal point
In table without data type DECIMAL is OK
Server: MS SQL 2008 Express, database collation is Czech_CI_AS.
Client: HeidiSQL Portable 18.104.22.16896, OS Win7 64-bit, WinXP Pro ( Czech localization )
My own application runs properly ( no problem with decimal point ), but I need from time to time edit data in table. Have You got any idea for solving this problem ?
have nice day
If I execute a query and some recordsets are displayed I can not copy&paste a floating point value.
If I change a value manually (by F2) I get this:
UPDATE `Anlagen` SET `Nennleistung`=8.45 WHERE `ID`=5277;
/* No error */
But with STRG+C and STRG-V I get this:
UPDATE `Anlagen` SET `Nennleistung`=8,45 WHERE `ID`=5288; #
/* SQL Fehler (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '45 WHERE `ID`=5288' at line 1 */
Server: MySQL 5.1.69, database collation is utf8_general_ci
Client: HeidiSQL 22.214.171.12429, Win7 64Bit (german)
Please login to leave a reply, or register at first.