Hi there,
I've been searching for about 6 hours to get a problem solved.
I installed MySQL 4.1.7 on the Debian web-server.
Normally this worked:
insert into logbook (userid,count,d of,aircrid,type aircr,departure ,destination,de ptime,arrtime,r emarks,nrto,nrl dg,seland,melan d,class1,class2 ,night,actinstr ,siminstr,flins tr,crss,asflins tr,dual,pic,tot dur)
VALUES ('1082213471',' 582','2004-11-22','PHUSJ','DV 20','EHAM','EHA M','10:00','11: 35','TEST','1', '1','00:45','', '','','','','', '','00:45','',' ','00:45','00:4 5');
Now, I get an error. And I think I know where the problem is. It has
something to do with the charsets and collation.
I surfed on the internet for hours, but could not find how I could
solve this error 1064:
#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 'dual,pic,totdu r) VALUES
('1082213471',' 582','2004-11-22','PHUSJ','DV 20','EHAM','' at line 1
The collation in the tabel is set to latin1_swedish_ ci.
The characterset is set to utf8.
When I change that (using phpmyadmin) to latin1, it still stays on
utf8.
I changed collation in the table of every row to utf8_general_ci , but
that did not work, too.
PLEASE HELP. I do not know anything I must do.
Greetings,
Temba
0  1458  This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: DH |
last post by:
I must work with phpMyAdmin 2.6.0-pl3 installed on a client's Windows NT
web server. I've not previously encountered options for charset and
collation using phpMyAdmin, and am not sure what to set "MySQL
connection collation" for English-US type usage.
The default MySQL charset: UTF-8 Unicode (utf8)
I didn't notice this until exporting a backup, which for different
tables is giving me different "CHARSET=latin1" values.
|
by: Bob Bedford |
last post by:
I've no access to mysql NG, so I ask here:
I've two identical tables (wich are created by usins the same script, but
must be separated).
When I execute a query wich return fields and do a UNION between them, I
get:
Illegal mix of collations for operation 'UNION'
I had an old mysql version on the server, and since my ISP upgraded, I have
|
by: Robert Mazur |
last post by:
Solaris 9 - sparc 64bit
MySQL 5.0 alpha (installed using binary from MySQL)
---------------------------------
Has anyone expereinced this? The client will launch locally and
process SQL queries. However when using the up arrow to view
previously entered SQL statements, the MySQL client throws:
Segmentation Fault (core dumped)
|
by: Andres Monroy-Hernandez |
last post by:
Hi,
I'm trying to compile the latest mysql source in a Sun box:
# uname -a
SunOS bucktown 5.8 Generic_108528-20 sun4u sparc SUNW,Ultra-80
My configration looks like this:
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \
-fno-exceptions -fno-rtti" ./configure \
|
by: Marcus |
last post by:
Hello,
I recently upgraded from 4.0 to 4.1. I've spent the last few days
reading up on charsets since I never really thought about it when I used
4.0. I thought I had most of it figured out, but then I saw this in
phpMyAdmin and am as confused as when I started:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8-unicode-ci (in a dropdown box)
| | |
by: Carlone |
last post by:
Hi, I'm using mysql 4.0.18 on a web server with PHP 5.1.1 and I'm trying to
pass from the iso-8859-1 encoding to utf8, but I'm still confused about
many questions.
With which encoding data is saved in the DB when data is generated by PHP?
Does it depend to the charset of the php page? And if the string is
inserted in a page by the user in a form and then inserted in the database?
There is any setting of mysql, or any property of the...
|
by: iksando |
last post by:
Hello,
I'm looking for solution in case insensitive search in MySql.
Table exemple.
CREATE TABLE `pozycje` (
`id` int(11) NOT NULL auto_increment,
`eid` varchar(20) collate latin2_bin default NULL,
`poz_nazwa` varchar(40) collate latin2_bin NOT NULL,
|
by: =?utf-8?B?UMSBdmVscyBNaWhhaWxvdnM=?= |
last post by:
Hello,
I have a problem. I've linked MySql server to MsSql, in MySql I have a
table with Latvian data(character set is ucs2, ucs2_general_ci) and
the problem is that when I use openquery to read data from MySQL
server, some characters are not translated correctly! I receive
question symbols instead of Latvian special characters.
Maybe someone had this kind of problem with collation?
|
by: alex |
last post by:
I've converted a latin1 database I have to utf8. The process has been:
# mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore
--skip-set-charset mydb mydb.sql
# iconv -f ISO-8859-1 -t UTF-8 mydb.sql mydb_utf8.sql
mysqlCREATE DATABASE mydb_utf8 CHARACTER SET utf8 COLLATE utf8_general_ci;
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
