For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > November 2006 > RE: [PHP-DB] Special Character









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author RE: [PHP-DB] Special Character
David Skyers

2006-11-16, 6:56 pm

Hi Niel

That's the problem I don't know what it is, but I do know that I press
the hyphen/minus key on my keyborad. If I type in 'The -' then press
enter and copy and paste this from word, it then gets displayed as
question mark in Oracle.

David

=20

-----Original Message-----
From: Niel Archer [mailto:Niel Archer] On Behalf Of Niel Archer
Sent: 16 November 2006 13:26
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Special Character

Hi

Is it really a hyphen, or is it an en- or em-dash. The latter two could
mess up in in some character sets.

Niel

--
PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
Niel Archer

2006-11-16, 6:56 pm

Hi David

What you describe sounds like Word is auto replacing hyphens with either
en- or em-dashes. This is a configurable option in Word that often
defaults to on. Try using double quotes, If they get switched to 66's
and 99's style quotes, then that is likely the problem. I no longer use
MS Office for these and other reasons, so cannot tell you how to switch
off this formatting. But it can be switched off, somewhere within it.

The only other option I can think of would be to change your Db
character set to one that can accept these extended characters. That
might also mean changing some of Window's/Word's behaviour (to be using
UTF-8 for example).

Niel
Dan Shirah

2006-11-16, 6:56 pm

To turn off the auto formatting of hyphens:

In Microsoft Word 2003:

Open a new document.
Go to Tools>Auto Correct Options>
Select the "Auto Format As You Type" tab
Deselect the "Hyphens (--) with Dash (-)" option.

Even though it says it will replace a double hyphen (--) with a Dash (This
is an em dash) it also does the same thing for a single hyphen depending on
the sentance structure.

Hope this helps!

Dan


On 11/16/06, Niel Archer <niel@catweasel.org> wrote:
>
> Hi David
>
> What you describe sounds like Word is auto replacing hyphens with either
> en- or em-dashes. This is a configurable option in Word that often
> defaults to on. Try using double quotes, If they get switched to 66's
> and 99's style quotes, then that is likely the problem. I no longer use
> MS Office for these and other reasons, so cannot tell you how to switch
> off this formatting. But it can be switched off, somewhere within it.
>
> The only other option I can think of would be to change your Db
> character set to one that can accept these extended characters. That
> might also mean changing some of Window's/Word's behaviour (to be using
> UTF-8 for example).
>
> Niel
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com