Re: international characters in db
For correct work all these things should be set to UTF-8:
1. Database, tables, fields encoding (you said you done it)
2. Your pages where you show/save data
3. Your Cake connection to DB (you said you done it)
4. phpMyAdmin connection to DB
If any of this items not in UTF-8 strange errors will occur. Like
somewhere "bushes", somewhere not.
On Jan 27, 1:02 am, kicaj wrote:
> I had problem still...
>
> This is my export db:
>
> CREATE TABLE IF NOT EXISTS `categories` (
> `name` varchar(255) collate utf8_unicode_ci NOT NULL
> PRIMARY KEY (`id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>
> INSERT INTO `categories` (`name`) VALUES
> ( 'ąćęłńóśżź'), // must by: ąćęłóń...
> ('ąćęłńóśżź'),
> ( 'ąćęłńóśżź'),
>
> Anyone know How I can repaire?
>
> On 25 Sty, 19:23, brian wrote:
>
> > Check the character encoding in your browser when you have phpmyadmin
> > open. This is a notorious issue with that application. The fix is to
> > set the encoding in the config file. Sorry, I can't be more specific
> > as I don't have a copy handy right now.
>
> > On Sun, Jan 25, 2009 at 7:11 AM, kicaj wrote:
>
> > > Hi
>
> > > I set in database.php encoding to utf8, my table and fields set to
> > > utf8-unicode-ci, and when i adding record to db, a see in my
> > > phpmyadmin "bushes", why?
>
> > > ...but in on the site all it's okey:)
>
> > > Sorry, for my english:)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: international characters in db
I had problem still...
This is my export db:
CREATE TABLE IF NOT EXISTS `categories` (
`name` varchar(255) collate utf8_unicode_ci NOT NULL
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `categories` (`name`) VALUES
( 'ąćęłńóśżź'), // must by: ąćęłóń...
('ąćęłńóśżź'),
( 'ąćęłńóśżź'),
Anyone know How I can repaire?
On 25 Sty, 19:23, brian wrote:
> Check the character encoding in your browser when you have phpmyadmin
> open. This is a notorious issue with that application. The fix is to
> set the encoding in the config file. Sorry, I can't be more specific
> as I don't have a copy handy right now.
>
> On Sun, Jan 25, 2009 at 7:11 AM, kicaj wrote:
>
> > Hi
>
> > I set in database.php encoding to utf8, my table and fields set to
> > utf8-unicode-ci, and when i adding record to db, a see in my
> > phpmyadmin "bushes", why?
>
> > ...but in on the site all it's okey:)
>
> > Sorry, for my english:)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: international characters in db
Check the character encoding in your browser when you have phpmyadmin open. This is a notorious issue with that application. The fix is to set the encoding in the config file. Sorry, I can't be more specific as I don't have a copy handy right now. On Sun, Jan 25, 2009 at 7:11 AM, kicaj wrote: > > Hi > > I set in database.php encoding to utf8, my table and fields set to > utf8-unicode-ci, and when i adding record to db, a see in my > phpmyadmin "bushes", why? > > ...but in on the site all it's okey:) > > > Sorry, for my english:) > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
international characters in db
Hi I set in database.php encoding to utf8, my table and fields set to utf8-unicode-ci, and when i adding record to db, a see in my phpmyadmin "bushes", why? ...but in on the site all it's okey:) Sorry, for my english:) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
