|
Home > Archive > FoxPro database connector > April 2005 > Store eurosign in memofield
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 |
Store eurosign in memofield
|
|
| Rob Boymans 2005-04-07, 8:05 pm |
| After I stored the euro sign € into a memofield, it changes to Ç
Any suggestions
thx
Rob
| |
| Rick Bean 2005-04-07, 8:05 pm |
| Rob,
I'd guess that you aren't using the same font to display the memo field =
as you are when it's entered. The character value is probably the same, =
but the display font doesn't support the euro character for this value.
Rick
"Rob Boymans" <rboymans@xs4all.nl> wrote in message =
news:424d53da$0$4932
4$e4fe514c@dreader17
.news.xs4all.nl...
> After I stored the euro sign =80 into a memofield, it changes to =C7
>=20
> Any suggestions
>=20
> thx
>=20
> Rob
| |
| Olaf Doschke 2005-04-07, 8:05 pm |
| > After I stored the euro sign € into a memofield, it changes to Ç
May be a code page issue.
What Codepage is the memo field?
?CPCURRENT()
?CPDBF("myTable")
or
DISPLAY STRUCTURE
You can prevent any codepage conversions, if
you make the memo a binary memo field:
create table...(mMemo M nocptrans).
I wonder though, if this is a codepage issue,
as the euro sign has become a standard ascii
sign CHR(128), which should work in any
codepage. ?!?
Bye, Olaf.
| |
| Dennis Longfellow 2005-04-07, 8:05 pm |
| Olaf,
>
> I wonder though, if this is a codepage issue,
> as the euro sign has become a standard ascii
> sign CHR(128), which should work in any
> codepage. ?!?
>
This is one of the reasons that I read through the newsgroups everyday.
I appreciate your input to these news groups.
Dennis Longfellow
| |
| Rob Boymans 2005-04-07, 8:05 pm |
| Olaf Doschke wrote:
>
> May be a code page issue.
>
> What Codepage is the memo field?
> ?CPCURRENT()
> ?CPDBF("myTable")
> or
> DISPLAY STRUCTURE
>
> You can prevent any codepage conversions, if
> you make the memo a binary memo field:
> create table...(mMemo M nocptrans).
>
> I wonder though, if this is a codepage issue,
> as the euro sign has become a standard ascii
> sign CHR(128), which should work in any
> codepage. ?!?
>
> Bye, Olaf.
>
>
>
>
thx,
it works,
Rob
|
|
|
|
|