A problem Between MySQL <> phpBB

mirable · #1 08-Sep-2003, 13:02

Hi
I have a problem between phpBB2 and MySQL

when a new member try's to register with a turkish name and using also turkish charset iso-8859-9 all works fine on the register status
but after when you look in the member list then appers the name like some symbol like this = mus78&@%*+@@#^&%

and i dumped also out the data from MySQL and it looks like :

INSERT INTO `phpbb_users` VALUES (208, 1, 'müh&#305;tin A&#3', '087c8abfaee44ebbf0c2871976a2ab18', 0, 0, 0, 1062970133, 0, 0, '0.00', 1, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 0, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, NULL, '', 0, 'mama@mama.com', '', '', '', '', '', '', '', '', '', '', '', NULL);

anyone know what happens between phpBB and MySQL ?

JdS · #2 08-Sep-2003, 17:19

Iam not sure about this since I have only ever dealt with web pages in English. I also realise that this is just an issue with a username...

If I were you I'd first look into changing this line in my templates, between the <head> and </head> tags.

Change:

HTML Code:


<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

to:

HTML Code:


<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

and see what happens... I'm also interested to figure out how you solve this eventually (if my suggestion fails to make a difference).

mirable · #3 09-Sep-2003, 05:23

Thanks first for replay to my question

i find the problem between phpBB - MySQL

I erased the php and installed it again
but this time i used in the install option for default language just >turkish < and now it works all fine .

thanks and sorry for my fault
but i did'n find out that this problem was so simple !
any way now it works all fine english and turkish name's can be added now as a member .

thanks again

JdS · #4 10-Sep-2003, 05:31

Thank you for the update...

IOW, you re-installed PHP to fix this?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
unwanted scrollbar problem	kelly001	Web Design Forum	3	24-Oct-2003 10:44
MySQL Security	misunderstood	MySQL / PHP Forum	1	02-Jul-2003 02:38
Windows: From only £20p/y,Linux: from $10p/m. ASP, ASP.NET, PHP, Free MySQL, +More	EyotaHosts	Web Hosting Advertisements & Offers	0	28-Jun-2003 13:54
can mysql run on a separate server?	zabell	MySQL / PHP Forum	6	06-Jun-2003 13:32
[Tutorial] MySQL Basics	nniehoff	MySQL / PHP Forum	15	23-Mar-2003 19:42

A problem Between MySQL <> phpBB

charset=utf-8?