What Charset Owns This Stubborn Character �

Welcome. Please Login, Register, Or Activate! 
type your username and password to login
Date: November 22, 2009, 07:42 AM
430694 members and 297828 Topics
Latest Member: victorojohwoh
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  Technology  |  Webmasters (Moderators: OmniPotens, yawa-ti-de)  |  What Charset Owns This Stubborn Character �
Pages: (1) Go Down Send this topic Notify of replies
Author Topic: What Charset Owns This Stubborn Character �  (Read 70 views)
webdezzi (m)
What Charset Owns This Stubborn Character �
« on: November 04, 2009, 06:09 PM »

hi all, I have spent close to 4 hours on this '�'
i really need to know what charset owns it, maybe that will mark the beginning of it's end
the stubborn thing keep coming up in my application
thanks
yawa-ti-de (f)
Re: What Charset Owns This Stubborn Character �
« #1 on: November 04, 2009, 06:46 PM »

It is not visible here so we can't say Wink

Do you define your charset in your HEAD tags (I use ISO-88 whatever and it pulls up pretty much every special character known to man)?
webdezzi (m)
Re: What Charset Owns This Stubborn Character �
« #2 on: November 04, 2009, 08:15 PM »

you mean u cant see this characters i am seeing?

����������
����������

character that looks like a square box standing on it's sharp edge, with a question mark in it?

i must be losing it!

the problem is during insertion into mysql DB, the DB table uses latin1_swedish_ci encoding and all i do is grab a newly arrived string coming via base64_encode/decode

say the data is "cool", i get this naughty character separate every character, to form something like c�o�o�l�

just before the database insertion, i echoed the string which gave me the correct "cool"
only to check my db to see the character litter everywhere.

somehow, this occurs only on fields with type varchar(), char text, these field has their individual charset set to latin1_swedish_ci
i try changing the column charsets but no luck

*dhtml
Re: What Charset Owns This Stubborn Character �
« #3 on: November 05, 2009, 06:22 AM »

same thing is messing up my current application - and i cant figure it out yet
webdezzi (m)
Re: What Charset Owns This Stubborn Character �
« #4 on: November 05, 2009, 02:40 PM »

i think this is getting tougher than it should.

I noticed that the character only shows up within my app,  when i use firefox.
other browsers do just fine.

I was hoping that when i view this nairaland thread in other browsers, i wont see the character, but nah!
other browsers displays the character so making me think, i have just started.

one thing tells me it's a firefox issue, another tells me it's some kind of physics am yet to understand.
time is not my friend on this project.

i would have opted for the mysql repace() function but what character will i be replacing, my editors can't take the character without transforming it to question mark(?), this character is obviously not question mark.
webdezzi (m)
Re: What Charset Owns This Stubborn Character �
« #5 on: November 05, 2009, 09:02 PM »

i finally got a solution, i just exported the sql only to discover that somehow, the character evaluates to '\0' (without the quotes) and this happens within mysql only.

so all i did was

insert into blabla (x,y,z) values(20, replace('abcd','\0',''), 'c')
since replace is a mysql function and not php's
so the conversion is happening right inside the war zone.

though i still need to go back to school to go learn characters and alphabet Grin Grin
*dhtml
Re: What Charset Owns This Stubborn Character �
« #6 on: November 05, 2009, 09:07 PM »

In my own case, i did something that converts from excel csv directly into html and then stored the html into dbase.
From what you said, i will try out some combinations and hope to solve the problem
*dhtml
Re: What Charset Owns This Stubborn Character �
« #7 on: November 05, 2009, 11:02 PM »

i noticed too after you said it that the character only comes up after i save that html into dbase. . .so i need to use that your
replace function to solve it then. . .
webdezzi (m)
Re: What Charset Owns This Stubborn Character �
« #8 on: November 05, 2009, 11:27 PM »

in what database  are u saving it in?
*dhtml
Re: What Charset Owns This Stubborn Character �
« #9 on: November 06, 2009, 03:36 AM »

mysql dbase. I made the application such that after conversion of excel (*.csv) to html, it saves it in dbase, and later allows
editing of the stuff with a web-based wysiwyg editor
 What Makes A Host Affordable And Reliable?  Four Steps Of Planning Your Site Content  Lets Make This Project A Reality!  Page 2
Pages: (1) Go Up Send Topic to Friend by E-mail Reply 


Sections: Autos/Cars (2) Jobs/Vacancies (2) (3) Career Talk Education General(2) Politics Romance Computers Phones Travel
Sports Fashion Health Religion Celebrities TV/Movies (2) Music/Radio (2) Books Webmasters Programming

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa. See also: Nairalist Classified Ads
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.