Cannot use åäö in usernames

[jonten123 +]

Running 4.1.8 Designer version

Using deepsea template


Hello,

I posted this as a bug, but I´m not sure if it is a bug so I´ll ask you guys as well. I cannot register a username that contains å, ä or ö. I get the message that only letters and characters are allowed. I have changed all class_user... tables and the class_registration table to utf8_swedish_ci. I have also opened the templates/default/user/userjoin.tpl in a text editor and saved it with the UTF8 encoding. I know nothing about coding but I added this line as well to the userjoin.tpl file <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> but nothing helps. This is something I need to fix before I go online with the script. I want companies to register with their company names as their usernames and many of them has å, ä or ö in their name.

Thanks!

[John Snyder +]

Odds are its a bug in the validation process. If you reported it as a bug it might be helpful to post a link to it here.

[jonten123 +]

Here´s a link to the posted bug Link

This might be of some help. The locations I added in the acp that starts with åäö looks strange in the database. For example, Örebo looks like Örebro in the database. That may also be why my a-z sorting is wrong with locations that starts with åäö. The sorting look´s like this now on my site, a, ä, ö, b, c and so on when it should be like this xyzåäö.Can I prevent åäö to look strange in the database?

[John Snyder +]

The character corruption occurs when you change the collation of the field, likely if you reenter it correctly from the admin or phpmyadmin it will display properly.

[jonten123 +]

I deleted Örebro and added it again. Still the same. The reason I have changed the charset/collation back and forward is because my categories and locations never have sorted correctly. And I just found out that nobody can register a username with åäö which is a dealbreaker for me. That must work...

[John Snyder +]

Have you seen this documentation and implemented it?

UTF-8 - 68 Classifieds

Also, be sure you add this: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> to the header in the layout.tpl file not the userjoin.tpl file.

[jonten123 +]

Hello,

The only thing I haven´t done is adding this line to the mysql file: $this->query("set names utf8");. All I get is fatal error on my page when adding it. I tried to add it at the end after ;exit(199); and in the middle and in the beginning but still fatal error. What am I doing wrong?

Edit: Just found out that I cant add the code to the mysql file in the designer version. I wonder if my åäö problem will disappear if I upgrades to the developer version? Then I can add the $this->query("set names utf8"); to the mysql file.. What do you guys think?

[Lhotch +]

I would recommend submitting a trouble ticket with a link to this forum thread. Explaine you cant follow the unicode instructions because you dont have the developer version. Im betting they will send you a new file with that change made.

[jonten123 +]

Hello,

Got the file today and added the $this->query("set names utf8"); to it. But all I get is a blank page. My site is not working with that line included. Did I paste the code in the wrong place?

function connectToDb () {
// Make connection to MySQL server
if (!$this->dbConn = @mysql_connect($this->host, $this->dbUser,$this->dbPass))
{
throw_db_error('Database Error', 'Could not connect to server');
$this->connectError=true;
// Select database
}
else if ( !@mysql_select_db($this->dbName,$this->dbConn) )
{
throw_db_error('Database Error', 'Could not select database');
$this->connectError=true;
}
}
$this->query("set names utf8");
/**
* Disconnects from the database server
*
* @return bool TRUE on success, FALSE on failure
*/

[Lhotch +]

Originally Posted by jonten123

Hello,

Got the file today and added the $this->query("set names utf8"); to it. But all I get is a blank page. My site is not working with that line included. Did I paste the code in the wrong place?

Ii looks like you have it outside the function as outlined in the docs, should look like this.....

function connectToDb () {
		// Make connection to MySQL server
		if (!$this->dbConn = @mysql_connect($this->host, $this->dbUser,$this->dbPass)) 
		{
			throw_db_error('Database Error', 'Could not connect to server');
			$this->connectError=true;
			// Select database
		} 
		else if ( !@mysql_select_db($this->dbName,$this->dbConn) ) 
		{
			throw_db_error('Database Error', 'Could not select database');
			$this->connectError=true;
		}
                $this->query("set names utf8");
	}