Hi,
I don't know where to ask this question, and I hope this is the right
group for this.
I've made one ASP+Access site. On that site I have few parts where
it's grabbing data from the database, and shows only those that match
particular query. When it's open, url looks something
like: ...data.asp?city=Dubrovnik
Now, here is a problem. I wasn't thinking, and during adding datas in
database, I was using special croatian characters (like èæ¾¹...). When
user choose a page that contains croatian charactes, url looks
something like: ...data.asp?city=I%E8i%E6i. Codepage is windows-1250
It works fine when people are following links from my site, but when
I've made a sitemap, google shows "unreachable url's" on every page
that contains croatian charactes. For example, I've made letter "è" on
my sitemap as "%E8", but google change "%E8" to "%C4%8D", and then I'm
getting a message: "ADODB.Field error '800a0bcd'. Either BOF or EOF is
True, or the current record has been deleted", because there is no
such record in database.
Is there any way to solve it, except rearanging entire site? I've
tried other ways of coding, but non of them are working. 1 1637
>>>>
<ss********@gmail.comwrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...
Hi,
I don't know where to ask this question, and I hope this is the right
group for this.
I've made one ASP+Access site. On that site I have few parts where
it's grabbing data from the database, and shows only those that match
particular query. When it's open, url looks something
like: ...data.asp?city=Dubrovnik
Now, here is a problem. I wasn't thinking, and during adding datas in
database, I was using special croatian characters (like èæ¾¹...). When
user choose a page that contains croatian charactes, url looks
something like: ...data.asp?city=I%E8i%E6i. Codepage is windows-1250
It works fine when people are following links from my site, but when
I've made a sitemap, google shows "unreachable url's" on every page
that contains croatian charactes. For example, I've made letter "è" on
my sitemap as "%E8", but google change "%E8" to "%C4%8D", and then I'm
getting a message: "ADODB.Field error '800a0bcd'. Either BOF or EOF is
True, or the current record has been deleted", because there is no
such record in database.
Is there any way to solve it, except rearanging entire site? I've
tried other ways of coding, but non of them are working.
<<<<
Change your DB to contain City table with Int (Long) Primary Key as an ID
for the city. Then use numeric IDs in your URLs instead.
Yes I know that's not what you want to hear however in the long run your DB
will be better off for it anyway. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steve Kushubar |
last post by:
I originally posted this in the internet.iis group and it was suggested that
I repost it here.
I am trying to use the Response.CodePage method on a Windows 2000 IIS
Server. The MSDN clearly...
|
by: Christopher H. Laco |
last post by:
Long story longer. I need to get web user input into a backend system
that a) only grocks single byte encoding, b) expectes the data transer
to be 1 bytes = 1 character, and c) uses the HP Roman-6...
|
by: Kim Bundgaard |
last post by:
Hi
Anyone know where I can look for problem with codepage conversion between
DB2 UDB Connect EE V8.2 (fixpak 3) and DB2 UDB z/OS V7.
With DB2 UDB Connect EE V7.2 (fixpak 7) i get Ebcdic X'5A'...
|
by: Vladimir Khvostov |
last post by:
Hi,
We have some DB2 table on the host that has varchar(3200) columns that
are used to store binary data (I know that "varchar(3200) for bit
data" should have been used, by modifying host table is...
|
by: Ram |
last post by:
Dear All,
Good Day
I am trying to convert a file which is generated on AS400 with codepage 00420 (arabic & English data combination) with no success. But using the same code( and changing 20420...
| |
by: Mike Prager |
last post by:
Hi,
I have written a Hotmail type application where users choose their language
preference which is used to set the culture and hence the correct resource
files for strings, formatting etc. I...
|
by: Daatmor |
last post by:
I saved my aspx with Encoding (Chinese Tranditional (Big5) - Codepage 950)
and I had set codepage="950" in Page tag. The content rendered incorrect
(all text changed to symbols), but some content...
|
by: asklucas |
last post by:
Hi there,
I got an MS Access DB, which is causing problems when the client PC is
running using a Traditional Chinese codepage.
The DB was probably created with Access 97, Western European...
|
by: eyal.herlin |
last post by:
hi,
i set a cookie to hold a utf-8 string. either by the server or by the
client. it doesn't matter.
when i try to read this cookie using Request.Cookies("my_utf8_cookie")
on iis 5.0 i get...
|
by: msdnuniv |
last post by:
Hello everybody,
since days i try to convert Unicode-Strings in VB.NET to ANSI which should
be processable in VB6 and converted to unicode again.
It should be possible with any codepage, e.g....
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |