Tokyoj

Topic: Admin-->Pages : Doublebyte doesn't work. Why not?

From Admin-->Page, I've been trying to edit Contact Us, About Us and Widget pages but ????????? is all I get when encoding in doublebyte characters.
How can the encoding be changed for the current 3 pages as well as all new pages I create from Admin-->Pages.
(All other translation has gone smoothly with the .ini file.)
The problem is only Admin-->Pages.

Thank you.

---------------
Tokyoj
"You can't build a reputation on what you're going to do." (Henry Ford)
"Insanity is doing the same thing over and over, expecting different results." (Albert Einstein)

Tokyoj

Re: Admin-->Pages : Doublebyte doesn't work. Why not?

Well here's what I tinkered with...and it works....
(please note my SQL skills are limited and this solution is based solely on 'common sense'...not database experience. Please backup your DB BEFORE you start.)

1. Login to your host control panel (mine is Cpanel)
2. Click PHPMyAdmin
3. Select your jobberbase DB from left side panel. That will open a list of tables (which Jobberbase uses) below in the same left side panel
4. select 'page' because that is the table to the site uses when generating 'new page' and Contact Us, About Us, and Widgets.
5. In the middle of screen you'll see a table with rows (for the fields) and columns (for configuration).
6. Look down through the 'Collation' column and you'll see various entries, Latin1_swedish_ci, UFT8_unicode, etc...
7. Select the field (row) that you want to change the collation (encoding) for.
8. Select the pencil icon at the bottom of the rows
9. Select the collation ('encoding') you want/need
10. Click 'Save'
11. Repeat for all fields that you need change.

Again...please note there are alot better developers here then me, so if someone would like to edit, add, delete any of the above steps, please do so. We'd all welcome correct info.

---------------
Tokyoj
"You can't build a reputation on what you're going to do." (Henry Ford)
"Insanity is doing the same thing over and over, expecting different results." (Albert Einstein)

Anonymous

Re: Admin-->Pages : Doublebyte doesn't work. Why not?

Yeah, Japanese doesn't work, so I decided to use my corporate site instead of JobberBase's own page structures.

Thanks for sharing the solution. But speaking from my experience, just like TokyoJ as a non developer, you can select your database collation when you make a new db from phpmyadmin.

My db for this job board is set to UTF8_general (something like that), but still I can't type Japanese via Pages function from admin panel.

Tokyoj

Re: Admin-->Pages : Doublebyte doesn't work. Why not?

socialpreneur,
I fixed the doublebyte issue using the solution above. I can type Mandarin into pages I create using Admin Control-->Pages. For example, I created a Hot Link's page with descriptions of various links in Chinese and the links themselves in English (of course)... so I'm assuming Japanese is OK...they're both doublebyte...

---------------
Tokyoj
"You can't build a reputation on what you're going to do." (Henry Ford)
"Insanity is doing the same thing over and over, expecting different results." (Albert Einstein)