Save and show Strings from all users. /ASP

[webstaffuk]

Hi,
I wonder if someone can help or advise , Im using DW CS3 and have a few forms that are on asp pages.

These forms take a users input and save it to a database then display it on another page if needed.

This is all fine except when a user outwith the UK enters something and seem to add odd chars into the text boxes or accents from french input or apostrophies that differ from UK keyboards....

Is there a generic setting or similar that I can add to my pages to save and show anything from anyone?
Am I missing anything? I use charset=UTF-8 on all of my pages.

Do I need to run a replace function on every text box / area that takes input?
If I need to use a replace function Can someone advise on this as I have tried this a little with not much success...

Or is there something in DV im missing that can aid me?

Thanks again
W

[Newsgroup_User]

webstaffuk wrote:
> Hi,
> I wonder if someone can help or advise , Im using DW CS3 and have a few forms
> that are on asp pages.
>
> These forms take a users input and save it to a database then display it on
> another page if needed.
>
> This is all fine except when a user outwith the UK enters something and seem
> to add odd chars into the text boxes or accents from french input or
> apostrophies that differ from UK keyboards....
>
> Is there a generic setting or similar that I can add to my pages to save and
> show anything from anyone?
> Am I missing anything? I use charset=UTF-8 on all of my pages.
>
> Do I need to run a replace function on every text box / area that takes input?
> If I need to use a replace function Can someone advise on this as I have tried
> this a little with not much success...
>
> Or is there something in DV im missing that can aid me?
>
> Thanks again

It might be the datatype you are using for the column in your database.
What are you using?

Steve

[webstaffuk]

Hi Steve,
They get entered as 'adVarWChar' generally these fields are for names and similar strings.. sometimes i have them as memo fields in the database and they are set to go in as 'adLongVarWChar'

Regards

[Newsgroup_User]

webstaffuk wrote:
> Hi Steve,
> They get entered as 'adVarWChar' generally these fields are for names and
> similar strings.. sometimes i have them as memo fields in the database and they
> are set to go in as 'adLongVarWChar'
>
> Regards
>

What database are you using? What is the collation of your database set to?

Steve

[webstaffuk]

Hi Steve Its an Access 2003 database, Not sure where to find out what the collation is can you guide me as to where to look?

[Newsgroup_User]

webstaffuk wrote:
> Hi Steve Its an Access 2003 database, Not sure where to find out what the collation is can you guide me as to where to look?

Ahh, I don't think Access databases use it the same as MS SQL or MySQL.

Do you know the difference between varchar and nvarchar data types? If
your using UTF-8 and wanting to store extended information then you
should be using nvarchar. The N means it stores 2 bytes of information,
not 1, per character.

Thats assuming these data types even exist in Access 2003...I don't have
it so can't really help on that.

Steve