| Author |
 Topic Search  Topic Options
|
rsorrells 
Newbie
Joined: 03 July 2006
Location: United States
Status: Offline
Points: 7
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Apostrophes, quotation marks, etc.
Posted: 09 July 2006 at 10:31pm |
Hello,
I need help troubleshooting when there's an apostrophe and quote in the text. I can't get it to break when only a small amount of text... only several thousand characters.
Before: Make sure you don't photograph the backs of people.
After: Make sure you donÃt photograph the backs of people.
I'm saving to a MSSQL 2000 table, with the varable type of ntext.
I'm also not using a SQL statement... rather a recordset object, so I'm not doing any character substitution.
Any troubleshooting suggestions?
Thanks,
Bob
p.s. I did determine that the text is being written correctly to the database. These extra characters are appearing when the data is read back from the database and loaded into RTE.
Edited by rsorrells - 10 July 2006 at 12:02am
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 July 2006 at 9:26am |
|
Try setting a character set that supports the language you are using in the head of your web page.
|
|
|
|
rsorrells
Newbie
Joined: 03 July 2006
Location: United States
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 July 2006 at 11:44am |
I'm using the default character set, which for default.asp file in the RTE folder uses
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
I've isolated it further.
before: They're made
after: They’re made
I did a loop through the string, and this ’ thing, whatever it is, is treated in ASP as a single character, with a length of 1.
As a work-around, I could actually do a substitution of ' for ’, but I can't figure out the string equivalent of ’. Its treated as a single character.
I tried sMyString = Replace(sMyString, "’", " ") and that doesn't work.
Thanks,
Bob
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 July 2006 at 1:04pm |
|
This seems very odd and does seem like some sort of encoding problem on the server.
Check your database is using the same encoding as your web pages.
|
|
|
|
bchavez
Newbie
Joined: 14 July 2006
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 July 2006 at 5:34pm |
|
Hi!!
I'm trying the RTE and it's really cool but I have the same problem, my
site is in spanish, with no other editors I tryed i had this problem,
in spanish there are á, é, í, ó, ú, Á, É, Í, Ó, Ú, ñ, Ñ, but the editor
don't let me use it because it put the extrange symbols... I don't know
why instead of put for á á put those extrange symbols... I use a simple Access database...
How can I solve this problem, do you know, I really like RTE but this problem is big....
regards
Edited by bchavez - 14 July 2006 at 5:35pm
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 July 2006 at 8:55pm |
What you mention is something completely different and has been covered a number of times, here just one post that covers the issue you have with page encoding:- http://forums.webwiz.net/forum_posts.asp?TID=19881
|
|
|
|
rsorrells
Newbie
Joined: 03 July 2006
Location: United States
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 July 2006 at 4:30pm |
I finally figured it out !! 
The default.asp code ships like this:
<title>Web Wiz Rich Text Editor</title>
<!--#include file="RTE_configuration/browser_page_encoding_inc.asp" -->
It needs to be like this:
<!--#include file="RTE_configuration/browser_page_encoding_inc.asp" -->
<title>Web Wiz Rich Text Editor</title>
I figured it out by starting with a clean page in Dreamweaver, and I kept adding code from the default.asp until it broke, and then found that this was the key difference.
Also I used charset=iso-8859-1 in browser_page_encoding_inc.asp.
Bob
Edited by rsorrells - 15 July 2006 at 4:32pm
|
|
bchavez
Newbie
Joined: 14 July 2006
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2006 at 2:23pm |
|
Hi!!
Tks, I read all the other post, but it still makeing me the same... can
you tell me why if I write directly in the html source á,
when It writes convert directly to á and don't write the á
for me it's extrange... do you know why....
regards
|
|
Apostrophes, quotation marks, etc.