Unicode question

Hi Team,

I'm not an expert in ASP but can manage. I am writing a script to randomly select text from the database. (Microsoft Access). The database has (Sankrit font) Proverbs that I am displaying randomly on the home page. The script that I have written does the job but when displaying the text I get (????????????????????/???) I'm sure it is problem with text that needs to be displayed. here is an ex: of what is stored in the databse.

नेहाभिक्रमनाशोस्ति प्रत्यवायो न विद्यते ।
स्वल्पमप्यस्य धर्मस्य त्रायते महतो भयात् ॥२-४०॥

When I run the script for showing all the records in the table the proverb is shown perfectly but it is not the same on when showing randomly. I'm not sure why?

Below is the script that I have used for random.

Expand|Select|Wrap|Line Numbers

 <%

    Option Explicit

    Response.Buffer = True

%>

<html>

<head>

    <style>

    p { font-family:verdana; font-size:11px; }

    </style>

</head>

<body>

<br><p align="center">

<%

    ' ADO Constant. Dont change this

    Const adCmdText = &H0001
 
        ' Connection string and SQL statement

    Dim query, connStr

        query = "select sloka from Slokas"

        connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _

                Server.MapPath("slokas.mdb")
 
        ' Opening database

    Dim rs

        Set rs = Server.CreateObject("ADODB.Recordset")

        rs.Open query, connStr, 3, , adCmdText
 
        ' Generating random number from total number of records

    Dim intRnd

        Randomize Timer

        intRnd = (Int(RND * rs.RecordCount))
 
        ' Now moving the cursor to random record number

        rs.Move intRnd
 
        ' Showing the random statement

        Response.Write "<b>" & rs("Sloka") & "</b>"
 
        ' Closing the database

        rs.Close

        Set rs = Nothing

%>

</p>

</body>

</html>

Can you please let me know where I have gone wrong?

Thanks,
Raam

Sep 5 '07 #1

Subscribe Post Reply

1469

jhardman

3,406

Expert 2GB

Raam,

This is an HTML issue, as far as I know. Are you stating a text encoding in the HTML?

Jared

Sep 5 '07 #2

markrawlingson

346

Expert 100+

I would take a look at your randomizer function first.

If there is only 1 record in your database it will always return as 0.

RND generates a random number between 0 and 1 (eg: 0.23421)
INT, simply drops any numbers after the decimal place. So say RND generates even the maximum number it can...

0.999 * 1 = 0.999

With INT wrapped around that it will drop anything after the decimal place and return 0. It does not round up like a lot of people think it does.

Also, even if the database always has more than 1 record - that randomizer function can return 0 still.

Say the db has 5 records and RND returns 0.020

0.020 * 5 = 0.100

With INT wrapped around it 0.100 = 0

In addition - Because of that, the last record in the database will never get displayed. If the recordCount is 10 - the maximum number that will be returned is 9, if the recordcount is 20 - the maximum number that will be returned is 19 - etc etc.

Fairly certain that's not what's causing the ????? to be displayed but it's still important and I just though i'd mention that... cause you can't move to record 0...

But it's an easy fix.

Expand|Select|Wrap|Line Numbers

Int(RND * rs.RecordCount + 1)

Sep 6 '07 #3

raamkum

Raam,

This is an HTML issue, as far as I know. Are you stating a text encoding in the HTML?

Jared

Nope I am not.. actually i'm just printing what ever is there in the datbase...!! So it should actually print what ever is there... just confused with it?

Sep 8 '07 #4

raamkum

I would take a look at your randomizer function first.

If there is only 1 record in your database it will always return as 0.

RND generates a random number between 0 and 1 (eg: 0.23421)
INT, simply drops any numbers after the decimal place. So say RND generates even the maximum number it can...

0.999 * 1 = 0.999

With INT wrapped around that it will drop anything after the decimal place and return 0. It does not round up like a lot of people think it does.

Also, even if the database always has more than 1 record - that randomizer function can return 0 still.

Say the db has 5 records and RND returns 0.020

0.020 * 5 = 0.100

With INT wrapped around it 0.100 = 0

In addition - Because of that, the last record in the database will never get displayed. If the recordCount is 10 - the maximum number that will be returned is 9, if the recordcount is 20 - the maximum number that will be returned is 19 - etc etc.

Fairly certain that's not what's causing the ????? to be displayed but it's still important and I just though i'd mention that... cause you can't move to record 0...

But it's an easy fix.

Expand|Select|Wrap|Line Numbers

Int(RND * rs.RecordCount + 1)

As of now I have 5 records in the database and it is randomizing perfectly. I tested it with one record as "Test Record number 5" as the text I get this text perfectly other text are randomized with showing "???????????"

Sep 8 '07 #5

jhardman

3,406

Expert 2GB

Nope I am not.. actually i'm just printing what ever is there in the datbase...!! So it should actually print what ever is there... just confused with it?

This is the problem then (as far as I can tell). Browsers are set up to display english characters by default. To let them know there are other characters you need to include a note saying which set of character codes you are going to use. Here is Wikipedia's explanation, which shows how to set the encoding tag. Here is an old site I found which explains how to display sanskrit characters. I hope this helps. I wouldn't be able to test this for you since I do not have those fonts installed on my computer.

Jared

Sep 8 '07 #6

by: sebastien.hugues | last post by:

Hi I would like to retrieve the application data directory path of the logged user on windows XP. To achieve this goal i use the environment variable APPDATA. The logged user has this name:...

Python

Q: The `print' statement over Unicode

by: François Pinard | last post by:

Hi, people. I hope someone would like to enlighten me. For any application handling Unicode internally, I'm usually careful at properly converting those Unicode strings into 8-bit strings before...

Python

UTF-8 & Unicode

by: EU citizen | last post by:

Do web pages have to be created in unicode in order to use UTF-8 encoding? If so, can anyone name a free application which I can use under Windows 98 to create web pages?

.NET Framework

Converting UTF-16 encoded chars in querystring to unicode

by: Supratim | last post by:

Hi, For past few weeks I am working on a function that would take encoded Unicode characters from query string of http requests and then decode them back to Unicode numbers. I have full success...

HTML / CSS

html symbols and unicode

by: dalei | last post by:

My question is presented more clearly in following web page: http://www.pinyinology.com/signs2.html <html> HTML entities display outside script tags: a¹, a², a³, a⁴ But...

Javascript

unicode mess in c++

by: damjan | last post by:

This may look like a silly question to someone, but the more I try to understand Unicode the more lost I feel. To say that I am not a beginner C++ programmer, only had no need to delve into...

C / C++

Array of Bytes to Unicode chars (ISO-8859-1)

by: abhi147 | last post by:

Hi , I want to convert an array of bytes like : {79,104,-37,-66,24,123,30,-26,-99,-8,80,-38,19,14,-127,-3} into Unicode character with ISO-8859-1 standard. Can anyone help me .. how should...

C / C++

byte count unicode string

by: willie | last post by:

Martin v. LÃ¶wis: Thanks for the thorough explanation. One last question about terminology then I'll go away :) What is the proper way to describe "ustr" below? <type 'unicode'>

Python

[MFC] CRichEditCtrl how to set codepage for Unicode?

by: =?Utf-8?B?S2V2aW4gVGFuZw==?= | last post by:

In MFC, CRichEditCtrl contrl, I want to set the codepage for the control to Unicode. I used the following method to set codepage for it (only for ANSI or BIG5, etc, not unicode). How should I...

.NET Framework

Encoding: how to convert ISO-8559 to Unicode

by: deloford | last post by:

Hi This is going to be a question for anyone who is an expert in C# Text Encoding. My situation is this: I have a Sybase database which is firing back ISO-8559 encoded strings. I am unable to...

.NET Framework

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...

Oracle Database

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...

PHP

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...

General

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

General

Problems to capture mouse_down event on a control within a form with lots of controls

by: Ricardo de Mila | last post by:

Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

Microsoft Access / VBA

Similar topics