Report Builder or Delphi i think unicode problem

hi,
primarily My versions
Delphi® 2009  Version 12.0.3210.17555 Trial (Update 1 now) (i try update 2,3,4)
report builder 11.06
Mssql 2005 9.0.3042 (Database Lang TURKISH_CI_AS) Template Field TEXT
Windows 7 Turkish

i create new projct, and placed ado datasets(or sdac) and ppreport and ppPipeline.

i set template.format=ftASCII
i set template.saveto=stDatabase

select template field REPORT_DESIGN (Mssql 2005 TEXT field)

Not any sets (tTable.Fields, ppreport.Fields etc.) (I tried by these set ttable.fields memo,widememo,blob,unkown etc.)

i try this design time :
-open connection and table
-Double click ppreport1
-file->new report->Report Wizard
-select fields and create report designs
-file->save as
-new report name and save the report

when i look REPORT_DESIGN field on TDBMemo, memo fills ?????????????>?????????? etc
if i select mssql field type NTEXT Field Filss like chinese characters

please look at this Sql server profiler capture :
-----------------------------------------------------------
declare @p27 int
set @p27=159
exec sp_executesql N'INSERT INTO Reports
  (RAPOR_ADI, RAPOR_GRUP, SQL_1, SQL_2, SQL_3, RAPOR_DIZAYN, SQL_4, SQL_5, SQL_6, SQL_7, SQL_8, SQL_9, SQL_10, BOLUM, GRUP, KUP_RAPORMU, SATIR_GRUP_ARA_TOP, SUTUN_GRUP_ARA_TOP, SATIR_GENEL_TOP, SUTUN_GENEL_TOP, MAT_ISLEM, STIL, SAYI_BICIM)
VALUES
  (@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13, @P14, @P15, @P16, @P17, @P18, @P19, @P20, @P21, @P22, @P23, @P24)
SET @P25 = SCOPE_IDENTITY()',N'@P1 nvarchar(16),@P2 varchar(1),@P3 varchar(1),@P4 varchar(1),@P5 varchar(1),@P6 varchar(4024),@P7 varchar(1),@P8 varchar(1),@P9 varchar(1),@P10 varchar(1),@P11 varchar(1),@P12 varchar(1),@P13 varchar(1),@P14 varchar(1),@P15 varchar(1),@P16 bit,@P17 bit,@P18 bit,@P19 bit,@P20 bit,@P21 varchar(1),@P22 varchar(1),@P23 varchar(1),@P24 varbinary(1),@P25 int OUTPUT',N'ReportDesignTest',NULL,NULL,NULL,NULL,'????????›??????????°??????????????????????????????????????????????????????
????†?????????????????????????????????????????4??????????????????????????†??????????????????†????????????4????†??????????????????????????†??????????????????†????????????4????†??????????????????????????????°????†?????????????????????????????????????????????????????†????????????????????????????†?????????????????????????????????????????????',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,@p27 output
select @p27
-----------------------------------------------------------
While recording these characters going to server.
and template is invalid!

Thanks
0
caner
10/4/2009 10:51:27 PM
embarcadero.delphi.database 1294 articles. 0 followers. Follow

0 Replies
1057 Views

Similar Articles

[PageSpeed] 21

Reply:

Similar Artilces:

SA 5.5, Delphi, Titan, Report Builder Combo Problems
Hi, I'm seeking the help/experience from someone using the above combination. Report Builder allows you to save report structures to a DB. The table "Reports" has 3 fields Rid is an Autoinc, ReportName is a Varchar, and ReportTemplate is a Text field. RB report component gets wired up to this table. When I use this method I get the following error: "column ReportName in table Reports cannot be null SQL anywhere error -195" I do not believe that I am the cause of this error. If I break some rules and allow nulls in all the fields, the first record insert...

ANN: Delphi HTML Reports preview
Very simple to use - buid complex reports in 10 minutes. All you need to know - SQL, HTML, CSS. Use all power of HTML4 and CSS3 in any part of report. Features: Barcodes Multiline headers Groups Cross-tabs (any level) Transformations (cross-tab with range) Pictures (+from database) Master/Detail (any level) Supports all databases and db-libraries (writing adapter for any db-acess library takes only 5 minutes) Standalone reports - no need for delphi forms/datasets. 100% native Delhi code. All Delphi versions - from Delphi 6 to XE6 (VCL). 32/64 bit. Supports Unicode for...

Problem with Delphi 6 to Delphi 7 upgrade
I have just purchased Delphi XE because I have an immediate need of D7 which came for free with XE. I downloaded and installed D7 and I think I applied the Update 1 that I had also downloaded. After much messing around with old components, I have finally attempted to compile my D6 project with D7. I get the following error:- [Fatal Error] apm.dpr(225): Unit ExtDlgs was compiled with a different version of ExtCtrls.TPanel I have checked the library paths all point to D7 versions of everything and now am at a loss to know what to do next. Also checked the sequence to make sure that al...

Unicode problems on Delphi XE
Problem A: IBDataBase 1. Using InterBase 2007 DataBase 2. TIBDataBase -> (lc_ctype -> not declare) 3. TIBQuery do not display Taiwan Character (ASCII > 255) on DBGrid normally. -> It show in ASCII Code. Problem B: Memo update 1. Using InterBase 2007 2. TIBDataBase -> (lc_ctype = UNICODE_FSS) 3. TIBQuery display Taiwan Character in DBGrid normally. 4. BlobType (ftMemo) in TIBQuery can not be applyUpdated to TIBDataBase Correctly in using Unicode. Problem C: Memo transform 1. Using InterBase 2007 2. A TIBDataBase -> (lc_ctype = none)...

Delphi and Delphi for .Net
It seems that Delphi for .Net is slower than Delphi Win32 native applicaiton. I would like to know is it true all .Net application is slower than Win32 native applicaiton or it is Delphi for .Net only. Your information is great appreciated, Inung On 2011-06-21 18:20:17 +0100, Inung Huang said: > It seems that Delphi for .Net is slower than Delphi Win32 native applicaiton. > I would like to know is it true all .Net application is slower than > Win32 native applicaiton or it is Delphi for .Net only. If you are only running the code in the application once then, yes, yo...

converting delphi 2007 code to delphi XE2 -- emptyparam problem
Hi, I am trying to convert my applicantion code from delphi 2007 to delphi XE2 and i got stuck in this error "[DCC Error] ADODB_TLB.pas(4888): E2033 Types of actual and formal var parameters must be identical". This happens when we use emptyparam as an argument in a function that wants an olevariant. Example: function TAcadDatabase.CopyObjects(Objects: OleVariant): OleVariant; begin Result := DefaultInterface.CopyObjects(Objects, EmptyParam, EmptyParam); //this is where we get the ERROR end; The coyobjects function as this signature: " function CopyObjects(Object...

problem delphi 2010 apps with a delphi 5 pro Pchar
Hallo I build on till now alle tools and programas with delphi 5 pro now i have delphi 2010 want don't want rewite alle my DLL Tools Like The tool i made for making PDF In case of This DLL i can't becose the vcl i use in delphi 5 will not work in delphi 2010 *This call in apps* {code} Function GenratePDF(Settings:Pchar):Boolean; stdcall external 'GUPPDF2.dll'; {code} *In delphi 5 DLL* {code} Function GenratePDF(Settings:Pchar):Boolean; stdcall; {code} if call the function i get a "Access violation" i think that the settings parameter empty is...

Delphi 2006 to Delphi XE Crystal BPL problem [Edit]
I am in the process of migrating our application from Delphi 2006 to Delphi XE and, for ease of use, I have both 2006 and XE installed on my development computer. I access Crystal Reports XI RDC in our application and so I rebuilt the BPL in XE in order to add the new package to XE. However, when I try to add the package to XE I get the error message: “Registration procedure, Craxddrt_tbl.Register in the package c:\Documents and Settings\All Uers\Documents\RADS Studio\8.0\BPL\Crystal.bpl raised exception class EFilerError: Component TDatabase can’t be registered by package crystal.bpl be...

Ace reporter in Delphi/Builder 2009
Our company wants migrate our large project to Builder 2009. The problem is that we have hundreds reports in Ace Reporter and no upgrade for it is aviable. Is there any way to get Ace reporter working in 2009 or is there any reporter which can import reports from ace ? Dear Milan Bačík! You can send report templates to "virtual windows printer" and try convertor from XPS (windows printer format) to FastReport: http://fast-report.com/pbc_download/xps_converter.zip "Milan Bačík" wrote: news:105462@forums.codegear.com... > Our company wants migrate...

Problems with MSHTML_TLB on Delphi 2009(Unicode)
The first error I got when I add mshtml_tlb to the uses clause was "file not found: mshtml_tlb.dcu", so I tried to import and install the scriptlet (mshtml_tlb) component. After I imported and installed the component I now get about fifty errors like "IHTML... redeclared". Yep, they were all redeclaration issues. I am using delphi unicode, how can I get around this? Thanks in advance. > The first error I got when I add mshtml_tlb to the uses clause was > "file not found: mshtml_tlb.dcu", so I tried to import and install > the scriptlet (mshtml_tlb) co...

delphi 2010 variant to unicode problem
Please advise how I can achieve this. I am working in a dll in delphi 2010. This dll has a exported procedure that receives an array of variants. I want to be able to take one of these variants, and convert it into a string, but i keep getting ????? I cannot change the input variable - it HAS to be an array of variants. The host app that calls the dll cannot be changed. It is written in Delphi2006. sample dll's code is: ----- Procedure TestArr(ArrUID : array of variant);stdcall; var i : integer; s:string; begin s:= string(String(Arruid[0])); showmessage(s); ...

Delphi 2009 automatic bug reports appear as Delphi.NET issues
For automatic bug reports, Delphi 2009 seems to put 'Delphi.NET' into the field for 'Project'. I will try to verify it and enter it in QC. Unfortunately this means I have to use the QC database for 'testing', but will delete my test entries if I have verified the problem. Michael Justin Michael Justin wrote: > For automatic bug reports, Delphi 2009 seems to put 'Delphi.NET' into > the field for 'Project'. AFAIK this is as expected. There is no project "RAD Studio" and so "Delphi.NET" has been choosen as proj...

RAD Studio 2010 (Delphi, C++Builder, and Delphi Prism) Posted
All, The new roadmap for RAD Studio has been posted. Link: http://edn.embarcadero.com/article/39934 Enjoy, Mike Michael Rozlog wrote: > All, > > The new roadmap for RAD Studio has been posted. > > Link: http://edn.embarcadero.com/article/39934 > Thanks for the info, Mike. One thing I'm missing in the slides is the effort to bring the compiler into the C++ Standard compliance (lamda/closures, auto/decltype, etc.) I hope it's just an omission! :) Il Tue, 11 May 2010 09:01:04 -0700, Alex Bakaev <a@b.cc> ha scritto: >Than...

RAD Studio 2010 (Delphi, C++Builder, and Delphi Prism) Posted
All, The new roadmap for RAD Studio has been posted. Link: http://edn.embarcadero.com/article/39934 Enjoy, Mike "Michael Rozlog" <michael.rozlog@embarcadero.com> wrote in message news:241286@forums.embarcadero.com... > The new roadmap for RAD Studio has been posted. We have to wait all the way until Commodore to get better documentation? And until Chromium to get OTA documentation? -- Remy Lebeau (TeamB) On 10.05.2010 23:50, Michael Rozlog wrote: > All, > > The new roadmap for RAD Studio has been posted. > > Link: http://e...

Web resources about - Report Builder or Delphi i think unicode problem - embarcadero.delphi.database

Associated Builders and Contractors - Wikipedia, the free encyclopedia
^ "ABC Strategic Partnership - Maxwell Systems" . Maxwell Systems, Inc . Retrieved July 10, 2013 . Text is available under the Creative Commons ...

Cheezburger Builder Turns Facebook Photos Into Memes
... the Internet love using Cheezburger to turn photos into memes , but now users can connect their Facebook accounts into the Cheezburger Builder ...

JetSet Secrets, MeuChip, Cinemagram, Jurassic Park Builder and more on this week’s emerging Facebook ...
... Deluxe 790,000 +90,000 + 13% 10. High 5 Casino 318,775 +81,001 + 34% 11. Talkatone 240,000 +80,000 + 50% 12. Jurassic Park Builder ...

Dream Builders (@NBCDreamBuilder) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Business Builders Community
Business Builders is a group for professionals who are business and entrepreneur minded who understand the power and value of networking to grow ...

Sport Athlete Builder - Kids Learn Cool Sports Facts on the App Store on iTunes
Get Sport Athlete Builder - Kids Learn Cool Sports Facts on the App Store. See screenshots and ratings, and read customer reviews.

Big farewell for Canberra biker, builder and friend
The roar of engines escorted Gregory McFawn to his final resting place on Monday, a fitting farewell to a man with two great loves: his family ...

Perth engineer’s robot bricklayer: See the Fastbrick Robotics builder in action
THIS is the robot bricklayer that is putting WA on the building map around the world with inquiries from 39 countries already.

WA builders clean up at national Master Builders awards - PerthNow Search Search
WA builders took out seven awards at the Master Builders awards on the Gold Coast, scooping the top prizes for their diverse range of skills ...

Big farewell for Canberra biker, builder and friend
The roar of engines escorted Gregory McFawn to his final resting place on Monday, a fitting farewell to a man with two great loves: his family ...

Resources last updated: 1/2/2016 7:46:49 AM