• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

MySQL 4.1 and Norwegian characters

C

CiViX

Guest
We have just migrated some webservers from RHEL3 running ARTs MySQL4.0 RPMs, too new servers with RHEL4 and native MySQL4.1.

After the migration Norwegian characters doesn't work in MySQL anymore. Norwegian charcters turn up as question marks: Tilbehør --> Tilbeh?r

I dumped the Tilbehør-table and used a search and replace tool to change all "Tilbehør" to "Tilbehor". I then dropped the Tilbehør-table and imported the edited SQL-dump. In the new table I have a column called TilbehorID. When I try to rename this to TilbehørID, I get the following error:

#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 'ørID` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT' at line 1
Click to expand...

Do I have to downgrade to MySQL4.0 again, og is there a way to make MySQL 4.1 recognize and accept Norwegian characters?
 
You must log in or register to reply here.

Similar threads

mariodieck
Question Attempt to restore the "psa" database from a dump fails.
Replies
1
Views
3K
Sebahat.hadzhi
Sebahat.hadzhi
H
Question Can't Export DBs, SQL Assertion Error
Replies
0
Views
2K
hostking
H
kristobal1969
Resolved Error messages with let's Encrypt when 1 serveur for main domain and another serveur for subdomain or mails
Replies
12
Views
7K
NataliaA
N
D
Forwarded to devs MySQL 8 database dump fails
Replies
8
Views
8K
Sebahat.hadzhi
Sebahat.hadzhi
M
Issue How to repair "plesk repair db"
Replies
4
Views
8K
scsa20
scsa20
Back
Top