Hi Friends,
I am facing a problem at the time of Updating or Inserting the UNICODE data. My Database is created with UNICODE(UTF8) support. I have a UNICODE data and at the time of updating/inserting with this UNICODE data It was throwing an error message as
"invalid byte sequence for encoding "UTF8": 0xa53
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server,...
gouse
Last Activity: May 30 '12, 04:47 AM
Joined: Feb 22 '07
Location:
-
invalid byte sequence for encoding "UTF8"
-
Get UNICODE data using libpq
Hi All,
I am using libpq 'C' interface to connect to the PostgreSQL database. The encoding of Database is UTF8 and it also contains a table with UNICODE data. By using PQconnectdb() I have made a connection with the database, Next I have also set the PGSetClientEnco ding() to UTF8, After this I am executing the select query using PQexec() command, but it was not giving the UNICODE data. Is there any step I am missing?
... -
Calling External 'C' Function in PostgreSQL
Hi,
I need to call a 'C' external function in my newly created PostgreSQL function. I am using PostgreSQL 8.2 Version. I Have tried it by creating a 'C' Dll in VC++ 6.0 and calling this function in PostgreSQL function. When I am calling the 'C' function, It gives me message saying "Missing Magic Block", On searching Internet I got 'fmgr.h' file and I have included this file in my source code and again compiling the DLL,... -
"Communication closed during authentication"
I have an error during performing the bulk data manipulation "communicat ion closed during authentication" .
Database: PostgreSQL 8.2.4
Driver psqlODBC 8.2 ANSI
Language: VB.Net 2008
OS Windows 7 Professional 64 bit. -
Communication closed during authentication.
I have an error during performing the bulk data manipulation "communicat ion closed during authentication" .
Database: PostgreSQL 8.2.4
Driver psqlODBC 8.2 ANSI
Language: VB.Net 2008
OS Windows 7 Professional 64 bit. -
Passing tablename as argument into function
Create or replace function Test(strTable in text) return bigint as
$$
declare
intSum bigint;
begin
intSum:=(Select sum(salary) from strTable);
return intSum;
end;
$$
language plpgsql;
select Test('Employee' );
I want to pass Table name as a argument into function and execute select statement on this table
I run this function error is... -
How to find duplicate values exists or not
Hi,
Can any one tell me how to find "duplicate values exists in columns or table". please reply as early as possible.
ThanQ -
Problem in converting float4 type to float8
Hi Friends,
when I have convert the float4 data type to float8 data type it was lossing the value. The following are the commands i Have used. Plaese go through it.
(1) TE TABLE tab1(id int PRIMARY KEY,val float4);
(2) INSERT INTO tab1 VALUES(1,1.1);
INSERT INTO tab1 VALUES(2,1.2);
INSERT INTO tab1 VALUES(3,1.3);
(3) When I Use the SELECT COMMAND (SELECT... -
Install MS SQL Server on WinXP
Hi All,
I want to install MS SQL Server 2000 (Developer Version) on WinXP SP2 (Workgroup) and make it database server to execute my client server application (Client machines are Winxp).
I select Domain Service Account to install SQL Server.
Now I can't register database in this configuration.
I face SSL Security Error message while registering new database.
Please suggest... -
Transaction Problem
Hi Friends,
I would like to set the properties of a transaction like ON_ERROR_ROLLBA CK . To set This parameter There is a psql command (meta command) \set.
ex: \set ON_ERROR_ROLLBA CK on
from the psql terminal it was working fine. But my problem is I am working with the libpq 'C' library in VC++. by uing this libpq library I am connecting to the database server. There is no sql command to use the above... -
Copy Table to other database
Hi Friends,
I would like to copy a table from one database to another database. How can I do this?
Please help me.
ThanQ -
rename a registry key
Hi All,
How to rename a registry key.
I have a key: HKEY_CURRENT_US ER\Software\MyP rogram\data. I want to rename "data" to "info". I still want to keep all the information and subkeys that are under it. -
User and Role
Hi All
I have 1 Admin role and 3 non admin roles (like user_1,user_2.. ..).
There are 10 Database (like 1,2,3....10) in my PostgreSQL sever.
I am admin and want to assign access (no objects creation, no objects modification ---> only view) rights to specific database among these non admin roles.
Eg.
Database 1,2 are only access by user 1 & 2
Database 3,4,5 are only... -
How To Execue Queris Fastly
Hi, Friends
I have a table with 2 lakh records (one text field, one int4 field, and a Gemetry field). When I was executing the query using Binary cursors, It was taking nearly 35 seconds. I am executing my query as follows
BEGIN;
DECLARE MyCursor BINARY CURSOR for select Field1,Field2(G eometry Field) from Table;
Fetch All into MyCursor;
Here I have Just write the loop from 1 to 200000... -
Starting More Than one Transaction
Hi,
Thanks To Moderator for your valuable and Quick reply.
I would like to start more than one transaction in single database connection using libpq 'c' interface. let explian me this one detail.
here I have started Transaction 'T1' and without ending that transaction again I would like to start another transaction 'T2'. How can I achieve This one Using the Libpq 'C' Interface.
ThanQ -
How to know the Number of Connection made with the database
hi friends,
I would like to know the number of connections made with a particular database and at the same time i like to restrict the number of connections from my VC++ Application. I am Using yhe 'libpq' interface. Is it there any way to do this.
ThanQ -
Fastly Inserting Records
Hello Friends,
In a Table I am inserting more than 50,000 Records one by one. It was taking a lot of time . Is it There any good approach/solution for inserting records more than 50,000 one by one in a fast manner. I have the same Problem in Updating of Records also. Please help me regarding this issue.
I am Using VC++ application As a Front End and libpq 'C' interface as a interface between my application and PostgreSQL... -
Back Up And Restore
Hi Friends,
I am Using the libpq 'C' interface as a interface in my VC++ Application. Here I would like to take a back up and restore that database using the libpq interface. Is it possible to take backup and restoring the database using the libpq 'C' Interface. If yes please give/send the solution.
ThankQ
No activity results to display