Unicode database support in Tiburon for Delphi and C++
In Tiburon, the next versions of Delphi and C++Builder, there is full support for Unicode throughout the language, the compiler, the runtime library, and the VCL. The basic String type is now a UnicodeString. As part of the Unicode support, there is also full support for Unicode characters in databases and database components. While Delphi and C++Builder have supported Unicode characters at the database level for some time, you know can use all of the VCL components to display and manipulate the Unicode characters.
I have an InterBase database from demos I did back when we first added support for Unicode in our DBX3 driver days. The database contains English, Greek, Hebrew, and Chinese strings in the CharField column. I create a VCL application with some database components: SQLConnection, SQLDataSet, DataSetProvider, ClientDataset, DataSource, DBGrid and DBLabel.
There are two ways to get a program to work with the Unicode database. 1) Open SQLConnection’s "params" property in the Object Inspector and create the name=value pair "ServerCharSet=UTF8". Then right mouse click on the SQLConnection component and choose "Refresh Connection String". Set the Connection active and now I have Unicode Characters in the DBGrid. 2) Modify the DBXConnections.xml file for your database connection to add "ServerCharSet=UTF8".
Here is the resulting VCL application form at design time:
Stay tuned to the developer network for Tiburon video previews. Also stay tuned to the CodeGear blogs for other employees who will preview Tiburon technologies.
Share This | Email this page to a friend
I woke up this morning at 5am. Turned on my computer and read the press release announcing that Embarcadero closed the acquisition of CodeGear from Borland Software. Both the Embarcadero and CodeGear web sites have a flash animation highlighting the combination of DatabaseGear and CodeGear focused on tools that let architects, designers, developers, and administrators "design it, build it, and run it".
What’s different today? This morning it was foggy and drizzly at my house south of Santa Cruz. There was no traffic on Highway 1 North on the way to work. Now the sun is coming out in Scotts Valley. We are now part of a 500 person, $100 million company focused on application developers and database professionals. We now have more people and resources to innovate and help you succeed than we had yesterday. We have joined together to focus on innovation in our existing products and the creation of new solutions.
Our mission is all about building software tools. It is about providing tools that are independent (and supportive) of a platform or stack vendor’s offerings. We’re about building software tools for students, hobbyists, developers, professionals, consultants, independents, and small/medium/large/extra-large businesses.
The rate of growth and volume of information and data is incredible. Information and software drives the modern economy. Applications are needed to process and present the information. People create the applications. Twenty five years ago, at the time of Turbo Pascal 1.0, there were two million developers in the world. Today, the number of developers is growing at approximately two million per year.
Some people would tell you that tools don’t matter. That open source or the platform and stack vendors will solve every problem and satisfy every pain point. Today, software is no more reliable, no more predictable than it was before. We need to build better applications, faster, and with higher reliability. Our economy needs every designer, architect, developer, and administrator to be performing at the top of their game.
What are we focused on? Building the best tools to let you leverage the skills you are developing no matter what operating system, database, platform, stack, hardware, and architecture you are using today so that you can use those skills on the infrastructures you will be using tomorrow.
We are the “un-lock-in”. For those of you that are dependent on platforms, databases – our tools can work with you and for you. For those who have heterogeneous infrastructures or for those individuals, consultants, ISVs/Micro ISVs, SI/VARs, and OEMs who need to support multiple platforms - our tools can work with you and for you. For those developers who don’t use databases - our tools can work with you and for you.
Information Engineering and Software Engineering have now collided at Embarcadero Technologies, the largest independent provider that empowers application developers and database professionals with tools to design, build, and run software applications in the environment they choose.
How can we innovate to help you succeed? Do any of the following pain points resonate with you?
- My professionals have no independence because we are tied to a single stack (platform).
- Our team is wasting tons of time and resources with low-quality tools.
- I am an individual developer who has to build it all while competing with larger teams.
- Our team is very distributed, disjointed, and disconnected.
- My small group still has to build complex apps.
- Information Management and Software Development are in different silos at our company.
- Software tools are hard to access and expensive for my team.
- We are an ISV that needs to build quality, performant, global-ready packaged software.
- We build scientific and industrial applications pushing the envelope of non-database applications.
- We use Eclipse but waste time with different plug-ins, multiple editions, and lack best-in-class tooling for real development work.