数据库中增加数据时出现错误1406，Data too long for column ‘Name‘ at row 1，解决办法。

最新推荐文章于 2024-05-21 17:31:17 发布
最新推荐文章于 2024-05-21 17:31:17 发布
阅读量7.2k 收藏 1
点赞数 1
文章标签： mysql
原文链接：https://blog.51cto.com/yin123/533912
版权

数据库中出现错误1406，Data too long for column ‘Name’ at row 1，解决办法。

在百度上面查了很多方法，发现都不管用，最后在一个大佬的博客上找到了一个很有用的方法：

修改MYSQL目录下的my.ini文件中的-default-character-set = gb2312或utf8，重启mysql再输入数据，如果不行，请参考原博客。
博客原网址：https://blog.51cto.com/yin123/533912

大汤源
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
解决data too long for column 'name' at row 1
ddfo79355的博客
04-30 2148
最先试一试最简单的测试方式就是先修改my.ini文件中的-default-character-set = gb2312或utf8，重启mysql再输入数据,如果不行，再考虑以下办法。 在程序中写了一段代码向数据库中插入数据，出现了data too long for column 'name' at row 1的问题。在google搜了一下解决方法，真是五花八门，也逐一试了一遍，终...
DevExpress VCL v2012 vol 1.6源码、例子、帮助-Part1
11-28
=====注意：一共2个压缩分卷，这是第1个！===== DevExpress VCL v2012 vol 1.6 Delphi VCL. 包含所有源码、例子、帮助 支持Metro啦！ What's New in DevExpress VCL 12.1.6 Release Notes The following sections list all minor and major changes in DevExpress VCL 12.1.6. Note that products, controls and libraries which aren't mentioned in the list below are included in the unified installer for compatibility, but have not been updated. New Features/Changes ExpressLayout Control S170028 - Documentation - Describe runtime object access capabilities in the "On-Form Object Access" topic S170040 - Documentation - Update the "ExpressLayout Control: Resource Strings" topic with resource strings used in customization context menus ExpressTile Control S170009 - Add the capability to determine if a specific point corresponds to a tile control's title using HitTest information Resolved Issues VCL Subscription Q434991 - Data-aware container controls - Format settings are not applied to cells ExpressBars Suite Q440463 - Ribbon - TdxBarApplicationMenu - Check marks displayed for TdxBarLargeButton items appear highly pixelated Q441061 - Ribbon - TdxRibbonBackstageView opened in a new Ribbon Form created in an application remains visible on screen if this Ribbon Form is closed via its Close button Q425185 - Ribbon Form - Incorrect text color is applied to a maximized form's caption B219006 - TcxBarEditItem - LookupComboBox - An error occurs when moving focus from one lookup bar item to another ExpressDocking Library Q440931 - TdxDockPanel is not activated by clicking the panel's tab in TdxTabContainerDockSite ExpressLayout Control Q434679 - A layout group fires the OnTabChanging event twice if the event's handler calls Application.ProcessMessages Q433283 - A layout group with a label layout item that is set to occupy the entire client area of its group has an incorrect width B218895 - Documentation - Incorrect topic navigation due to a corrupt HLP file (Delphi 7 only) ExpressPrinting System Q440760 - Export to PDF - The File Save dialog is not shown if the default file name for a report is too long B218629 - In the Page Number Format dialog, the "Start At" field value is incorrectly validated for character-based number formats B218627 - TBasedxReportLink descendants - Customized values of the TimeFormat, DateFormat and PageFormat properties are reset to their default values in some cases if default formats have been customized at the TdxComponentPrinter level Q440453 - TdxComponentPrinter - The Date And Time dialog cannot be re-opened after the last time format has been selected in the Available Time Formats list Q435027 - The Print Preview window freezes when invoked from a window located in a DLL file B219022 - TreeList Report Link - Rich text formatting is missing when printing cxRichEdit columns ExpressQuantumGrid Suite Q404033 - An exception is thrown when the selection is modified within the View's OnSelectionChanged event handler Q430561 - Assigning a Table View column to a Layout View data item or Card View row modifies the assignee's GroupIndex property Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-aware Views - The "RecordIndex out of range" exception is thrown when removing a record if the View contains unbound columns Q433982 - Data-aware Views - The "RowIndex out of range" exception is thrown when updating the TClientDataSet bound to the View within a form's OnDestroy event handler using EmptyDataSet, etc. B218884 - Layout View - Card captions and currently focused items are incorrectly painted in selected cards B218883 - Layout View - Cell content areas are hot-tracked regardless of the View's OptionsBehavior.ItemHotTrack property value B218885 - Layout View - The text color specified in the View's Styles.OnGetItemStyle event handler is not applied to card layout items Q438267 - Server Mode - Clicking a Filter Row cell in a column containing Null values throws the "Could not convert variant of type (Null) into type (OleStr)" exception Q435475 - Tabular and Layout Views - The View does not synchronize edit value changes with the data controller in the OnEditChanged event handler if DataController.Options includes dcoImmediatePost, and a grid item's Properties.ImmediatePost property is set to True ExpressQuantumTreeList Suite Q434260 - TcxDBTreeList refreshes all data if a bound dataset was edited via the TreeList control when the OptionsData.SmartRefresh property is set to True Q435693 - TcxTreeList - An AV occurs when adding nodes in RAD Studio XE3 at design time ExpressScheduler Suite Q431232 - cxDateNavigator - The date navigator does not maintain the number of selected weeks always visible on screen when scrolling months backwards Q433746 - Day View - Resizing an event that lasts more than one day past 11:59pm increases the event's duration by one day if the ShowAllDayEventsInContentArea property is set to True ExpressSkins Library Q435604 - TdxBevel - Additional colors are not defined for the control in the Blueprint, DevExpressStyle, Seven, SevenClassic, VS2010, and Whiteprint skins Q436337 - The Skin Editor does not generate skin packages for RAD Studio XE3 ExpressSpreadSheet B218380 - The TcxSSViewInfoData record fields in the cxSSViewInfo.hpp file generated by a C++Builder application have an invalid alignment ExpressTile Control Q432087 - cxDateEdit controls are not displayed on a detail page when activating this page for the second and subsequent times in Windows XP B218389 - Focus does not move to the previous/next row when it passes the first/last tile within the current row if a tile control's OptionsBehavior.FocusItemOnCycle property is set to True ExpressVerticalGrid Suite Q439250 - Closing the Customization form does not disable the customization mode in error Common Libraries ExpressEditors Library Q431767 - TdxDBBreadcrumbEdit does not update its content after a new record is inserted into a database table in XE2 Update 4 Q434043 - Background and text colors are not applied to a read-only editor if its Properties.ReadOnly property is set via RepositoryItem Q434045 - cxMemo - Scrollbars are not shown if the editor is the last object in a DFM file, the editor has no text, and its Properties.ScrollBars property is set to ssBoth at design time B218869 - dxBreadCrumbEdit - A node's DeleteChildren method does not update the node's HasChildren property Q437728 - dxBreadcrumbEdit - An AV occurs when clicking the Root in a node's drop-down window when the selected node's children are repopulated within an OnPathSelect event handler B213307 - ExpressEditors are erroneously painted by VCL styles, as if they are standard VCL editors Q436036 - Some editors discard changes to the edit value if these changes were made by pasting data from the clipboard, using the Backspace key, etc. Q433948 - TcxImage - Intersections with other transparent DevExpress editors may appear distorted Q440954 - TcxScrollBox - The Create method does not use the GetViewInfoClass method Q436691 - TcxShellBrowserDialog - Memory leaks when selecting a file or folder in the dialog and clicking the OK button Q432788 - TcxSplitter - In Delphi 2010 and later, changes to the AlignSplitter property erroneously cause form resizing Q434498 - TdxShellBreadcrumbEdit - An AV occurs when selecting a file in a linked shell tree view B218303 - TdxShellBreadcrumbEdit - Files selected in a linked shell tree view are added as nodes (folders) to the breadcrumb editor ExpressLibrary Q432285 - TdxScreenTip - An AV occurs when displaying hints for ExpressQuantumGrid cells after ScreenTips have been shown by hint controllers located on other forms
解决报错Data too long for column 'uid' at row 1 Query: insert into user values(?,?,?,?,?,?,?,?,?,?)
Imperfect girl的博客
02-12 4408
在程序中写了一段代码向数据库中插入数据，出现了data too long for column ‘name’ at row 1的问题。在google搜了一下解决方法，真是五花八门，也逐一试了一遍，终于终于将问题解决了。 下面先贴一下网上的众多解决 1、修改my.ini文件： 将sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SU...
一秒快速修正 mysql ERROR 1406 (22001): Data too long for column ‘name‘ at row 1
m0_57878331的博客
04-22 6749
这里列出两种方法 1.永久更改。 在MYSQL安装路径下找到 my.ini (Windows) 或者 my.cnf (Unix) 文件，把代码从上面的改成下面的
FastReport.v4.15 for.Delphi.BCB.Full.Source企业版含ClientServer中文修正版支持D4-XE5
12-10
FastReport.v4.15 for.Delphi.BCB.Full.Source企业版含ClientServer中文修正版支持Delphi 4-XE5 and C++Builder 6-XE5. D2010以上版本(D14_D19)安装必读 delphi2010以上版本(D14_D19)使用者安装时，请将res\frccD14_D19.exe更名名为frcc.exe frccD14_D19.exe是专门的delphi2010以上版本(D14_D19)编码器。其他低delphi版本，请使用frcc.exe FastReport® VCL is an add-on component that allows your application to generate reports quickly and efficiently. FastReport® provides all the tools necessary for developing reports, including a visual report designer, a reporting core, and a preview window. It can be used in Embarcadero (ex Borland and CodeGear) Delphi 4-XE5 and C++Builder 6-XE5. version 4.15 --------------- + Added Embarcadero RAD Studio XE5 support + Added Internal components for FireDac database engine + fixed bug with images in PDF export for OSX viewers + Added ability to set font charset to default in Style Editor - fixed duplex problem when printing several copies of the report - fixed problem with PNG images - fixed problem with TfrxPictureView transparent version 4.14 --------------- + Added Embarcadero RAD Studio XE4 support - [Lazarus] fixed bug with text output - [Lazarus] fixed bug with some visual controls in designer - [Lazarus] improved interface of the report preview and designer - [Lazarus] fixed bug with boolean propertyes in script code and expressions - fixed bug with endless loop in TfrxRichView - fixed bug with Unicode in TfrxMemoView appeared in previous release - improved MAPI interface in TfrxExportMail export - fixed some problems with allpication styles XE2/XE3 - improved compatibility with Fast Report FMX version 4.13 --------------- + Added Lazarus Beta support starts from Fast Report Professionnal edition. Current version allows preview, print and design report template under Windows and Linux platform (qt). + Added Embarcadero RAD Studio XE3 support - fixed compatibility with Fast Report FMX installed in the same IDE. This version can co exist with Fast Report FMX version at the same time. + published "Quality" property of TfrxPDFExport object + published "UseMAPI" property of TfrxExportMail object + published "PictureType" property to ODF export - fixed bug with expressions in RichEdit - fixed bug in multi-column reports - fixed exception in the report designer - fixed bug with URLs in Open Document Text and Open Document Spreadsheet exports - fixed format string in XLS OLE export - fixed format string in XLS BIFF8 export - fixed output of the check boxes on the highlighted lines in PDF export - fixed bug with PDF anchors - fixed bug when using two or more macroses in memo version 4.12 --------------- + added support of Embarcadero Rad Studio EX2 (x32/x64) + added export of Excel formulas in the BIFF export + added export of external URLs in the PDF export + added converter from Rave Reports ConverterRR2FR.pas + added Cross.KeepRowsTogether property + optimised merging cells in the BIFF export + added property DataOnly to exports + pictures format in all exports switched to PNG + improved number formats processing in the BIFF export + added property DataOnly to exports + added property TfrxODFExport.SingleSheet + added property TfrxSimpleTextExport.DeleteEmptyColumns + added property TfrxBIFFExport.DeleteEmptyRows + added progress bar to the BIFF export - fixed bug with frame for some barcode types - fixed wrong metafiles size in the EMF export - fixed processing of negative numbers in the OLE export - fixed bug in handling exceptions in the OLE export - fixed bug in creation of the progress bar (applicable to many exports) - fixed bug in the ODF export in strings processing - fixed bug in the OLE export in numbers formatting - fixed bug in the PDF export in rotating texts 90, 180 and 270 degrees - fixed bug in the ODF export in processing of headers and footers - fixed bug in the Text export in computing object bounds - fixed bug in the ODF export in UTF8 encoding - fixed hiding gridlines around nonempty cells in the BIFF export - fixed images bluring when exporting - fixed word wrapping in the Excel XML export version 4.11 --------------- + added BIFF8 XLS export filter + added to ODF export the Language property + [enterprise] added "scripts" folder for additional units ("uses" directive in report script) + [enterprise] added logs for scheduler (add info in scheduler.log) + [enterprise] added property "Reports" - "Scripts" in server configuration - set the path for "uses" directive in report script + [enterprise] added property "Http" - "MaxSessions" in server configuration - set the limit of maximum session threads, set 0 for unlimit + [enterprise] added property "Reports" - "MaxReports" in server configuration - set the limit of maximum report threads, set 0 for unlimit + [enterprise] added property "Logs" - "SchedulerLog" in server configuration - set the scheduler log file name + [enterprise] added property "Scheduler" - "Active" in server configuration - enable of scheduler + [enterprise] added property "Scheduler" - "Debug" in server configuration - enable writing of debug info in scheduler log + [enterprise] added property "Scheduler" - "StudioPath" in server configuration - set the path to FastReport Studio, leave blank for default - [enterprise] fixed bug with MIME types in http header (content-type) - [enterprise] fixed bug with default configuration (with missed config.xml) - [enterprise] fixed bug with error pages - fixed bug in XML export with the ShowProgress property - fixed bug in RTF export with font size in empty cells - fixed bug in ODF export with UTF8 encoding of the Creator field - fixed bug in XML export with processing special characters in strings - fixed bug in ODF export with properties table:number-columns-spanned, table:number-rows-spanned - fixed bug in ODF export with the background clNone color - fixed bug in ODF export with a style of table:covered-table-cell - fixed bug in ODF export with table:covered-table-cell duplicates - fixed bug in ODF export with excessive text:p inside table:covered-table-cell - fixed bug in ODF export with language styles - fixed bug in ODF export with spaces and tab symbols - fixed bug in ODF export with styles of number cells - fixed bug in ODF export with the background picture - fixed bug in ODF export with charspacing - fixed bug in ODF export with number formatting - fixed bug in ODF export with table-row tag - fixed bug in XLS(OLE) export with numbers formatting - fixed bug in RTF export with processing RTF fields - fixed bug with processing special symbols in HTML Export - fixed bug with UTF8 encoding in ODF export - fixed bug in PDF export with underlined, struck-out and rotated texts version 4.10 --------------- + added support of Embarcadero Rad Studio XE (Delphi EX/C++Builder EX) + added support of TeeChart 2010 packages (new series type aren't support in this release) + added a property TruncateLongTexts to the XLS OLE export that allows to disable truncating texts longer than a specified limit + added option EmbedProt which allows to disable embedding fonts into an encrypted PDF file + added TfrxDateEditControl.WeekNumbers property - fixed bug in XML and PDF exports with Korean charmap - fixed bug in the XLS XML export about striked-out texts - fixed bug about exporting an empty page via the XLS OLE export - fixed bug in the PDF export about coloring the background of pages - fixed bug in embedded designer when using break point in script - fixed bug with lost of focus in font size combo-box in designer - fixed bug with truncate of font size combo-box in Windows Vista/7 in designer (lost of vertical scroll bar) - fixed bug when lost file name in inherited report - fixed bug in multi-page report with EndlessHeight/EndlessWidth - fixed bug wit TfrxHeader.ReprintOnNewpage and KeepTogether - fixed bug in multi-column report with child bands - improved split mechanism (added TfrxStretcheable.HasNextDataPart for complicated data like RTF tables) - improved crosstab speed when using repeat band with crosstab object version 4.9 --------------- + added outline to PDF export + added anchors to PDF export - fixed bug with embedded TTC fonts in PDF export + added an ability to create multiimage TIFF files + added export headers/footers in ODF export + added ability to print/export transparent pictures (properties TfrxPictureView.Transparent and TfrxPictureView.TransparentColor) (PDF export isn't supported) + added new "split to sheet" modes for TfrxXMLExport + added support of /PAGE tag in TfrxRichView, engine automatically break report pages when find /PAGE tag + added ability to hide Null values in TfrxChartView (TfrxChartView.IgnoreNulls = True) + added ability to set any custom page order for printing (i.e. 3,2,1,5,4 ) + [enterprise] added variables "AUTHLOGIN" and "AUTHGROUP" inside the any report + [enterprise] now any report file can be matched with any (one and more) group, these reports are accessible only in matched groups + [enterprise] now you can set-up cache delays for each report file (reports.xml) + [enterprise] added new properties editor for reports in Configuration utility (see Reports tab) + [enterprise] added property "Xml" - "SplitType" in server configuration - allow to select split on pages type between none/pages/printonprev/rowscount + [enterprise] added property "Xml" - "SplitRowsCount" in server configuration - sets the count of rows for "rowscount" split type + [enterprise] added property "Xml" - "Extension" in server configuration - allow select between ".xml" and ".xls" extension for output file + [enterprise] added property "Html" - "URLTarget" in server configuration - allow select the target attribute for report URLs + [enterprise] added property "ReportsFile" - path to file with reports to groups associations and cache delays + [enterprise] added property "ReportsListRenewTimeout" in server configuration + [enterprise] added property "ConfigRenewTimeout" in server configuration + [enterprise] added property "MimeType" for each output format in server configuration + [enterprise] added property "BrowserPrint" in server configuration - allow printing by browser, added new template nav_print_browser.html + [enterprise] added dynamic file name generation of resulting formats (report_name_date_time) * [enterprise] SERVER_REPORTS_LIST and SERVER_REPORTS_HTML variables (list of available reports) depend from user group (for internal authentification) + added drawing shapes in PDF export (not bitmap) + added rotated text in PDF export (not bitmap) + added EngineOptions.IgnoreDevByZero property allow to ignore division by zero exception in expressions + added properties TfrxDBLookupComboBox.DropDownWidth, TfrxDBLookupComboBox.DropDownRows + added event TfrxCustomExportFilter.OnBeginExport + added ability to decrease font size in barcode object + added ability to inseret FNC1 to "code 128" barcode + added event TfrxPreview.OnMouseDown + added support of new unicode-PDF export in D4-D6 and BCB4-BCB6 * improved AddFrom method - anchor coping - fixed bug with WordWrap in PDF export - fixed bug with underlines in PDF export - fixed bug with rounded rectangles in PDF export - fixed CSV export to fit to the RFC 4180 specification - fixed bug with strikeout text in PDF export - fixed bug with incorrect export of TfrxRichView object in RTF format (wrong line spacing) - [enterprise] added critical section in TfrxServerLog.Write - fixed bug with setting up of the Protection Flags in the PDF export dialog window - fixed bug in PDF export (file structure) - fixed bug with pictures in Open Office Writer (odt) export - [enterprise] fixed bug with TfrxReportServer component in Delphi 2010 - fixed minor errors in Embarcedero RAD Studio 2010 - fixed bug with endless loop with using vertical bands together with page header and header with ReprintOnNewPage - fixed bug when using "Keeping" and Cross tables (incorrect cross transfer) - fixed bug with [CopyName#] macros when use "Join small pages" print mode - fixed bug when try to split page with endless height to several pages (NewPage, StartNewPage) - fixed bug with empty line TfrxRichView when adding text via expression - fixed bug when Footer prints even if main band is invisible (FooterAfterEach = True) - fixed resetting of Page variable in double-pass report with TfrxCrossView - fixed bug with loosing of aligning when split TfrxRichView - fixed buzz in reports with TfrxRichView when using RTF 4.1 version 4.8 --------------- + added support of Embarcadero Rad Studio 2010 (Delphi/C++Builder) + added TfrxDBDataset.BCDToCurrency property + added TfrxReportOptions.HiddenPassword property to set password silently from code + added TfrxADOConnection.OnAfterDisconnect event + added TfrxDesigner.MemoParentFont property + added new TfrxDesignerRestriction: drDontEditReportScript and drDontEditInternalDatasets + adedd checksum calculating for 2 5 interleaved barcode + added TfrxGroupHeader.ShowChildIfDrillDown property + added TfrxMailExport.OnSendMail event + added RTF 4.1 support for TfrxRichText object + [enterprise] added Windows Authentification mode + added confirmation reading for TfrxMailExport + added TimeOut field to TfrxMailExport form + added ability to use keeping(KeepTogether/KeepChild/KeepHeader) in multi-column report + added ability to split big bands(biggest than page height) by default * [enterprise] improved CGI for IIS/Apache server * changed PDF export (D7 and upper): added full unicode support, improved performance, decreased memory requirements old PDF export engine saved in file frxExportPDF_old.pas - changed inheritance mechanism, correct inherits of linked objects (fixups) - fixed bug with Mirror Mrgins in RTF, HTML, XLS, XML, OpenOffice exports - fixed bug when cross tab cut the text in corner, when corner height greater than column height - [fs] improved script compilation - improved WatchForm TListBox changet to TCheckListBox - improved AddFrom method - copy outline - Improved functional of vertical bands, shows memos placed on H-band which doesn't across VBand, also calculate expression inside it and call events (like in FR2) - Improved unsorted mode in crosstab(join same columns correctly) - Improved converter from Report Builder - Improved TfrxDesigner.OnInsertObject, should call when drag&drop field from data tree - improved DrillDownd mechanism, should work correct with master-detail-subtetail nesting - fixed bug with DownThenAcross in Cross Tab - fixed several bugs under CodeGear RAD Studio (Delphi/C++Builder) 2009 - fixed bug with emf in ODT export - fixed bug with outline when build several composite reports in double pass mode - fixed bug when group doesn't fit on the whole page - fixed "Page" and "Line" variables inside vertical bands - fixed bug with using KeepHeader in some cases - fixed bug with displacement of subreport when use PrintOnParent property in some cases - fixed small memory leak in subreports - fixed problem with PageFooter and ReportSymmary when use PrintOnPreviousPage property - fixed bug when designer shows commented functions in object inspector - fixed bug when designer place function in commented text block - fixed bug when Engine try to split non-stretcheable view and gone to endless loop - fixed bug with HTML tags in memo when use shot text and WordWrap - [enterprise] fixed bug with variables lost on refresh/export - fixed bug whih PDF,ODT export in Delphi4 and CBuilder4 - fixed bug with some codepage which use two bytes for special symbols (Japanese ans Chinese codepages) - fixed bug when engine delete first space from text in split Memo - fixed bug in multi-column page when band overlap stretched PageHeader - fixed bug with using ReprintOnNewPage version 4.7 --------------- + CodeGear RAD Studio (Delphi/C++Builder) 2009 support + [enterprise] enchanced error description in logs + added properties TfrxHTMLExport.HTMLDocumentBegin: TStrings, TfrxHTMLExport.HTMLDocumentBody: TStrings, TfrxHTMLExport.HTMLDocumentEnd: TStrings + improved RTF export (with line spacing, vertical gap etc) + added support of Enhanced Metafile (EMF) images in Rich Text (RTF), Open Office (ODS), Excel (XLS) exports + added OnAfterScriptCompile event + added onLoadRecentFile Event + added C++ Builder demos + added hot-key Ctrl + mouseWheel - Change scale in designer + added TfrxMemoView.AnsiText property - fixed bug in RTF export with EMF pictures in OpenOffice Writer - fixed some multi-thread isuues in engine, PDF, ODF exports - [enterprise] fixed integrated template of report navigator - [enterprise] fixed bug with export in Internet Explorer browser - fixed bug with font size of dot-matix reports in Excel and XML exports - fixed bug in e-mail export with many addresses - fixed bug in XLS export (with fast export unchecked and image object is null) - [enterprise] fixed bug in TfrxReportServer.OnGetVariables event - fixed bug in Calcl function - fixed memory leak in Cross editor - fixed progress bar and find dialog bug in DualView - fixed bug in PostNET and ean13 barcodes - fixed bug with TruncOutboundText in Dot Matrix report - fixed bugs with break points in syntaxis memo - improved BeforeConnect event in ADO - fixed bug in inhehited report with internal dataset - fixed bug in TfrxPanelControl with background color(Delphi 2005 and above) version 4.6 --------------- + added & , < , > to XML reader + added <nowrap> tag, the text concluded in tag is not broken by WordWrap, it move entirely + added ability to move band without objects (Alt + Move) + added ability to output pages in the preview from right to left ("many pages" mode), for RTL languages(PreviewOptions.RTLPreview) + added ability to storing picture cache in "temp" file (PreviewOptions.PictureCacheInFile) + added EngineOptions.UseGlobalDataSetList (added for multi-thread applications) - set it to False if you don't want use Global DataSet list(use Report.EnabledDataSet.Add() to add dataset in local list) + added new property Hint for all printed objects, hints at the dialog objects now shows in StatusBar + added new property TfrxDBLookupComboBox.AutoOpenDataSet (automatically opens the attached dataset after onActivate event) + added new property TfrxReportPage.PageCount like TfrxDataBand.RowCount + added new property WordWrap for dialog buttons (Delphi 7 and above). + added sort by name to data tree + added TfrxDesigner.TemplatesExt property + added TfrxStyles class in script rtti + changes in the Chart editor: ability to change the name of the series, ability to move created series, other small changes + [enterprise] added configurations values refresh in run-time + [enterprise] added new demo \Demos\ClientServer\ISAPI + [enterprise] added output to server printers from user browser (see config.xml "AllowPrint", set to "no" by default), note: experimental feature + [enterprise] added reports list refresh in run-time + [enterprise] added templates feature + [enterprise] improved speed and stability + [fs] added TfsScript.IncludePath property + [fs] added TfsScript.UseClassLateBinding property + [fs] fixed type casting from variant(string) to integer/float - changes in report inherit: FR get relative path from current loaded report(old reports based on application path works too) - corrected module for converting reports from Report Builder - fixed bug in CrossTab when set charset different from DEFAULT_CHARSET - fixed bug in RTF export with some TfrxRichView objects - fixed bug when print on landscape orientation with custom paper size - fixed bug when use network path for parent report - fixed bug with Band.Allowslit = True and ColumnFooter - fixed bug with drawing subreport on stretched band - fixed bug with embedded fonts in PDF export - fixed bug with long ReportTitle + Header + MaterData.KeepHeader = true - fixed bug with minimizing of Modal designer in BDS2005 and above - fixed bug with paths in HTML export - fixed bug with RTL in PDF export - fixed bug with SubReport in multi column page - fixed bug with Subreport.PrintOnParent = true in inherited report - fixed bug with SYMBOL_CHARSET in PDF export - fixed bug with the addition of datasets by inheritance report - fixed bug with width calculation when use HTML tags in memo - fixed compatibility with WideStrings module in BDS2006/2007 - fixed flicking in preview when use OnClickObject event - fixed free space calculation when use PrintOnPreviousPage - fixed preview bug with winXP themes and in last update - fixed subreports inherit - Thumbnail and Outline shows at right side for RTL languages - [fs] fixed bug with late binding version 4.5 --------------- + added ConverterRB2FR.pas unit for converting reports from Report Builder to Fast Report + added ConverterQR2FR.pas unit for converting reports from QuickReport to FastReport + added support of multiple attachments in e-mail export (html with images as example) + added support of unicode (UTF-8) in e-mail export + added ability to change templates path in designer + added OnReportPrint script event + added PNG support in all version (start from Basic) + added TfrxDMPMemoView.TruncOutboundText property - truncate outbound text in matrix report when WordWrap=false + added new frames styles fsAltDot and fsSquare + added new event OnPreviewDblClick in all TfrxView components + added ability to call dialogs event after report run when set DestroyForms = false + added ability to change AllowExpressions and HideZeros properties in cross Cells (default=false) + added IgnoreDupParams property to DB components + added auto open dataset in TfrxDBLookupComboBox + added new property TfrxADOQuery.LockType + added define DB_CAT (frx.inc) for grouping DB components + added TfrxPictureView.HightQuality property(draw picture in preview with hight quality, but slow down drawing procedure) + [FRViewer] added comandline options "/print filename" and "/silent_print filename" + added unicode input support in RichEditor + added new define HOOK_WNDPROC_FOR_UNICODE (frx.inc) - set hook on GetMessage function for unicode input support in D4-D7/BCB4-BCB6 + added ability chose path to FIB packages in "Recompile Wizard" + added new function TfrxPreview.GetTopPosition, return a position on current preview page + added new hot-keys to Code Editor - Ctrl+Del delete the word before cursor, Ctrl+BackSpace delete the word after cursor(as in Delhi IDE) + added "MDI Designer" example - all language resources moved to UTF8, XML - fixed bug with html tags [sup] and [sub] - fixed width calculation in TfrxMemoView when use HTML tags - fixed bug with suppressRepeated in Vertical bands - fixed bug when designer not restore scrollbars position after undo/redo - fixed visual bug in toolbars when use Windows Vista + XPManifest + Delphi 2006 - fixed bug in CalcHeight when use negative LineSpace - fixed bug in frx2xto30 when import query/table components, added import for TfrDBLookupControl component - fixed bug with Cross and TfrxHeader.ReprintOnNewPage = true - fixed converting from unicode in TfrxMemoView when use non default charset - [fs] fixed bug with "in" operator - fixed bug with aggregate function SUM - fixed bug when use unicode string with [TotalPages#] in TfrxMemoView - fixed bug with TSQLTimeStampField field type - fixed designer dock-panels("Object Inspector", "Report Tree", "Data Tree") when use designer as MDI or use several non-modal designer windows - fixed bug with hide/show dock-panels("Object Inspector", "Report Tree", "Data Tree"), now it restore size after hiding - fixed bug in XML/XLS export - wrong encode numbers in memo after CR/LF - fiexd bug in RTF export - fixed bug with undo/redo commands in previewPages designer - fixed bug with SuppressRepeated when use KeepTogether in group - fixed bug with SuppressRepeated on new page all events fired twice(use Engine.SecondScriptcall to determinate it) version 4.4 --------------- + added support for CodeGear RAD Studio 2007 + improved speed of PDF, HTML, RTF, XML, ODS, ODT exports + added TfrxReportPage.BackPictureVisible, BackPicturePrintable properties + added rtti for the TfrxCrossView.CellFunctions property + added properties TfrxPDFExport.Keywords, TfrxPDFExport.Producer, TfrxPDFExport.HideToolbar, TfrxPDFExport.HideMenubar, TfrxPDFExport.HideWindowUI, TfrxPDFExport.FitWindow, TfrxPDFExport.CenterWindow, TfrxPDFExport.PrintScaling + added ability recompile frxFIB packages in "recompile wizard" + added ability to set color property for all teechart series which support it + added, setting frame style for each frame line in style editor + added TfrxPreview.Locked property and TfrxPreview.DblClick event + added 'invalid password' exception when load report without crypt + added new parameter to InheritFromTemplate (by default = imDefault) imDefault - show Error dialog, imDelete - delete duplicates, imRename - rename duplicates + added property TfrxRTFExport.AutoSize (default is "False") for set vertical autosize in table cells * redesigned dialog window of PDF export * improved WYSIWYG in PDF export - fixed bug, the PageFooter band overlap the ReportSummary band when use EndlessHeight - fixed bug with lage paper height in preview - fixed bug with outline and encryption in PDF export - fixed bug with solid arrows in PDF export - fixed bug when print TfrxHeader on a new page if ReprintOnNewPage = true and KeepFooter = True - fixed bug when used AllowSplit and TfrxGroupHeader.KeepTogether - fixed page numbers when print dotMatrix report without dialog - fixed bug with EndlessHeight in multi-columns report - fixed font dialog in rich editor - [fs] fixed bug when create TWideStrings in script code - fixed bug with dialog form when set TfrxButtonControl.Default property to True - fixed twice duplicate name error in PreviewPages designer when copy - past object - fixed bug with Preview.Clear and ZmWholePage mode - fixed bug with using "outline" together "embedded fonts" options in PDF export - fixed multi-thread bug in PDF export - fixed bug with solid fill of transparent rectangle shape in PDF export - fixed bug with export OEM_CODEPAGE in RTF, Excel exports - fixed bug with vertical size of single page in RTF export - fixed bug with vertical arrows in PDF export - fixed memory leak with inherited reports version 4.3 --------------- + added support for C++Builder 2007 + added encryption in PDF export + added TeeChart Pro 8 support + added support of OEM code page in PDF export + added TfrxReport.CaseSensitiveExpressions property + added "OverwritePrompt" property in all export components + improved RTF export (WYSIWYG) + added support of thai and vietnamese charsets in PDF export + added support of arrows in PDF export * at inheritance of the report the script from the report of an ancestor is added to the current report (as comments) * some changes in PDF export core - fixed bug with number formats in Open Document Spreadsheet export - fixed bug when input text in number property(Object Inspector) and close Designer(without apply changes) - fixed bug in TfrxDBDataset with reCurrent - fixed bug with memory leak in export of empty outline in PDF format - line# fix (bug with subreports) - fixed bug with edit prepared report with rich object - fixed bug with shadows in PDF export - fixed bug with arrows in designer - fixed bug with margins in HTML, RTF, XLS, XML exports - fixed bug with arrows in exports - fixed bug with printers enumeration in designer (list index of bound) - fixed papersize bug in inherited reports version 4.2 --------------- + added support for CodeGear Delphi 2007 + added export of html tags in RTF format + improved split of the rich object + improved split of the memo object + added TfrxReportPage.ResetPageNumbers property + added support of underlines property in PDF export * export of the memos formatted as fkNumeric to float in ODS export - fixed bug keeptogether with aggregates - fixed bug with double-line draw in RTF export - fix multi-thread problem in PDF export - fixed bug with the shading of the paragraph in RTF export when external rich-text was inserted - fixed bug with unicode in xml/xls export - fixed bug in the crop of page in BMP, TIFF, Jpeg, Gif - "scale" printmode fixed - group & userdataset bugfix - fixed cross-tab pagination error - fixed bug with round brackets in PDF export - fixed bug with gray to black colors in RTF export - fixed outline with page.endlessheight - fixed SuppressRepeated & new page - fixed bug with long time export in text format - fixed bug with page range and outline in PDF export - fixed undo in code window - fixed error when call DesignReport twice - fixed unicode in the cross object - fixed designreportinpanel with dialog forms - fixed paste of DMPCommand object - fixed bug with the export of null images - fixed code completion bug - fixed column footer & report summary problem version 4.1 --------------- + added ability to show designer inside panel (TfrxReport.DesignReportInPanel method). See new demo Demos\EmbedDesigner + added TeeChart7 Std support + [server] added "User" parameter in TfrxReportServer.OnGetReport, TfrxReportServer.OnGetVariables and TfrxReportServer.OnAfterBuildReport events + added Cross.KeepTogether property + added TfrxReport.PreviewOptions.PagesInCache property - barcode fix (export w/o preview bug) - fixed bug in preview (AV with zoommode = zmWholePage) - fixed bug with outline + drilldown - fixed datasets in inherited report - [install] fixed bug with library path set up in BDS/Turbo C++ Builder installation - fixed pagefooter position if page.EndlessWidth is true - fixed shift bug - fixed design-time inheritance (folder issues) - fixed chm help file path - fixed embedded fonts in PDF - fixed preview buttons - fixed bug with syntax highlight - fixed bug with print scale mode - fixed bug with control.Hint - fixed edit preview page - fixed memory leak in cross-tab version 4.0 initial release --------------------- Report Designer: - new XP-style interface - the "Data" tab with all report datasets - ability to draw diagrams in the "Data" tab - code completion (Ctrl+Space) - breakpoints - watches - report templates - local guidelines (appears when you move or resize an object) - ability to work in non-modal mode, mdi child mode Report Preview: - thumbnails Print: - split a big page to several small pages - print several small pages on one big - print a page on a specified sheet (with scale) - duplex handling from print dialogue - print copy name on each printed copy (for example, "First copy", "Second copy") Report Core: - "endless page" mode - images handling, increased speed - the "Reset page numbers" mode for groups - reports crypting (Rijndael algorithm) - report inheritance (both file-based and dfm-based) - drill-down groups - frxGlobalVariables object - "cross-tab" object enhancements: - improved cells appearance - cross elements visible in the designer - fill corner (ShowCorner property) - side-by-side crosstabs (NextCross property) - join cells with the same value (JoinEqualCells property) - join the same string values in a cell (AllowDuplicates property) - ability to put an external object inside cross-tab - AddWidth, AddHeight properties to increase width&height of the cell - AutoSize property, ability to resize cells manually - line object can have arrows - added TfrxPictureView.FileLink property (can contain variable or a file name) - separate settings for each frame line (properties Frame.LeftLine, TopLine, RightLine, BottomLine can be set in the object inspector) - PNG images support (uncomment {$DEFINE PNG} in the frx.inc file) - Open Document Format for Office Applications (OASIS) exports, spreadsheet (ods) and text (odt) Enterprise components: - Users/Groups security support (see a demo application Demos\ClientServer\UserManager) - Templates support - Dynamically refresh of configuration, users/groups D2010以上版本(D14_D19)安装必读 delphi2010以上版本(D14_D19)使用者安装时，请将res\frccD14_D19.exe更名名为frcc.exe frccD14_D19.exe是专门的delphi2010以上版本(D14_D19)编码器。其他低delphi版本，请使用frcc.exe
DevExpress VCL 2012 vol 1.6源码、例子、帮助-Part1
11-28
=====注意：一共2个压缩分卷，这是第1个！===== DevExpress VCL v2012 vol 1.6 Delphi VCL. 包含所有源码、例子、帮助 支持Metro啦！ What's New in DevExpress VCL 12.1.6 Release Notes The following sections list all minor and major changes in DevExpress VCL 12.1.6. Note that products, controls and libraries which aren't mentioned in the list below are included in the unified installer for compatibility, but have not been updated. New Features/Changes ExpressLayout Control S170028 - Documentation - Describe runtime object access capabilities in the "On-Form Object Access" topic S170040 - Documentation - Update the "ExpressLayout Control: Resource Strings" topic with resource strings used in customization context menus ExpressTile Control S170009 - Add the capability to determine if a specific point corresponds to a tile control's title using HitTest information Resolved Issues VCL Subscription Q434991 - Data-aware container controls - Format settings are not applied to cells ExpressBars Suite Q440463 - Ribbon - TdxBarApplicationMenu - Check marks displayed for TdxBarLargeButton items appear highly pixelated Q441061 - Ribbon - TdxRibbonBackstageView opened in a new Ribbon Form created in an application remains visible on screen if this Ribbon Form is closed via its Close button Q425185 - Ribbon Form - Incorrect text color is applied to a maximized form's caption B219006 - TcxBarEditItem - LookupComboBox - An error occurs when moving focus from one lookup bar item to another ExpressDocking Library Q440931 - TdxDockPanel is not activated by clicking the panel's tab in TdxTabContainerDockSite ExpressLayout Control Q434679 - A layout group fires the OnTabChanging event twice if the event's handler calls Application.ProcessMessages Q433283 - A layout group with a label layout item that is set to occupy the entire client area of its group has an incorrect width B218895 - Documentation - Incorrect topic navigation due to a corrupt HLP file (Delphi 7 only) ExpressPrinting System Q440760 - Export to PDF - The File Save dialog is not shown if the default file name for a report is too long B218629 - In the Page Number Format dialog, the "Start At" field value is incorrectly validated for character-based number formats B218627 - TBasedxReportLink descendants - Customized values of the TimeFormat, DateFormat and PageFormat properties are reset to their default values in some cases if default formats have been customized at the TdxComponentPrinter level Q440453 - TdxComponentPrinter - The Date And Time dialog cannot be re-opened after the last time format has been selected in the Available Time Formats list Q435027 - The Print Preview window freezes when invoked from a window located in a DLL file B219022 - TreeList Report Link - Rich text formatting is missing when printing cxRichEdit columns ExpressQuantumGrid Suite Q404033 - An exception is thrown when the selection is modified within the View's OnSelectionChanged event handler Q430561 - Assigning a Table View column to a Layout View data item or Card View row modifies the assignee's GroupIndex property Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-aware Views - The "RecordIndex out of range" exception is thrown when removing a record if the View contains unbound columns Q433982 - Data-aware Views - The "RowIndex out of range" exception is thrown when updating the TClientDataSet bound to the View within a form's OnDestroy event handler using EmptyDataSet, etc. B218884 - Layout View - Card captions and currently focused items are incorrectly painted in selected cards B218883 - Layout View - Cell content areas are hot-tracked regardless of the View's OptionsBehavior.ItemHotTrack property value B218885 - Layout View - The text color specified in the View's Styles.OnGetItemStyle event handler is not applied to card layout items Q438267 - Server Mode - Clicking a Filter Row cell in a column containing Null values throws the "Could not convert variant of type (Null) into type (OleStr)" exception Q435475 - Tabular and Layout Views - The View does not synchronize edit value changes with the data controller in the OnEditChanged event handler if DataController.Options includes dcoImmediatePost, and a grid item's Properties.ImmediatePost property is set to True ExpressQuantumTreeList Suite Q434260 - TcxDBTreeList refreshes all data if a bound dataset was edited via the TreeList control when the OptionsData.SmartRefresh property is set to True Q435693 - TcxTreeList - An AV occurs when adding nodes in RAD Studio XE3 at design time ExpressScheduler Suite Q431232 - cxDateNavigator - The date navigator does not maintain the number of selected weeks always visible on screen when scrolling months backwards Q433746 - Day View - Resizing an event that lasts more than one day past 11:59pm increases the event's duration by one day if the ShowAllDayEventsInContentArea property is set to True ExpressSkins Library Q435604 - TdxBevel - Additional colors are not defined for the control in the Blueprint, DevExpressStyle, Seven, SevenClassic, VS2010, and Whiteprint skins Q436337 - The Skin Editor does not generate skin packages for RAD Studio XE3 ExpressSpreadSheet B218380 - The TcxSSViewInfoData record fields in the cxSSViewInfo.hpp file generated by a C++Builder application have an invalid alignment ExpressTile Control Q432087 - cxDateEdit controls are not displayed on a detail page when activating this page for the second and subsequent times in Windows XP B218389 - Focus does not move to the previous/next row when it passes the first/last tile within the current row if a tile control's OptionsBehavior.FocusItemOnCycle property is set to True ExpressVerticalGrid Suite Q439250 - Closing the Customization form does not disable the customization mode in error Common Libraries ExpressEditors Library Q431767 - TdxDBBreadcrumbEdit does not update its content after a new record is inserted into a database table in XE2 Update 4 Q434043 - Background and text colors are not applied to a read-only editor if its Properties.ReadOnly property is set via RepositoryItem Q434045 - cxMemo - Scrollbars are not shown if the editor is the last object in a DFM file, the editor has no text, and its Properties.ScrollBars property is set to ssBoth at design time B218869 - dxBreadCrumbEdit - A node's DeleteChildren method does not update the node's HasChildren property Q437728 - dxBreadcrumbEdit - An AV occurs when clicking the Root in a node's drop-down window when the selected node's children are repopulated within an OnPathSelect event handler B213307 - ExpressEditors are erroneously painted by VCL styles, as if they are standard VCL editors Q436036 - Some editors discard changes to the edit value if these changes were made by pasting data from the clipboard, using the Backspace key, etc. Q433948 - TcxImage - Intersections with other transparent DevExpress editors may appear distorted Q440954 - TcxScrollBox - The Create method does not use the GetViewInfoClass method Q436691 - TcxShellBrowserDialog - Memory leaks when selecting a file or folder in the dialog and clicking the OK button Q432788 - TcxSplitter - In Delphi 2010 and later, changes to the AlignSplitter property erroneously cause form resizing Q434498 - TdxShellBreadcrumbEdit - An AV occurs when selecting a file in a linked shell tree view B218303 - TdxShellBreadcrumbEdit - Files selected in a linked shell tree view are added as nodes (folders) to the breadcrumb editor ExpressLibrary Q432285 - TdxScreenTip - An AV occurs when displaying hints for ExpressQuantumGrid cells after ScreenTips have been shown by hint controllers located on other forms
DevExpress VCL v2012 vol 1.6源码-例子-帮助-part1
11-29
=============================== ==注意：一共2个压缩包，这是第1个== =============================== DevExpress VCL v2012 vol 1.6 包含所有源码、例子、帮助 如果你安装过其它版本的DevExpressVCL，安装前请完全卸载老版本的Dev控件，并执行“清理Dev残余文件”，清理System32下的DevExpress的BPL文件。 What's New in DevExpress VCL 12.1.6 Release Notes The following sections list all minor and major changes in DevExpress VCL 12.1.6. Note that products, controls and libraries which aren't mentioned in the list below are included in the unified installer for compatibility, but have not been updated. New Features/Changes ExpressLayout Control S170028 - Documentation - Describe runtime object access capabilities in the "On-Form Object Access" topic S170040 - Documentation - Update the "ExpressLayout Control: Resource Strings" topic with resource strings used in customization context menus ExpressTile Control S170009 - Add the capability to determine if a specific point corresponds to a tile control's title using HitTest information Resolved Issues VCL Subscription Q434991 - Data-aware container controls - Format settings are not applied to cells ExpressBars Suite Q440463 - Ribbon - TdxBarApplicationMenu - Check marks displayed for TdxBarLargeButton items appear highly pixelated Q441061 - Ribbon - TdxRibbonBackstageView opened in a new Ribbon Form created in an application remains visible on screen if this Ribbon Form is closed via its Close button Q425185 - Ribbon Form - Incorrect text color is applied to a maximized form's caption B219006 - TcxBarEditItem - LookupComboBox - An error occurs when moving focus from one lookup bar item to another ExpressDocking Library Q440931 - TdxDockPanel is not activated by clicking the panel's tab in TdxTabContainerDockSite ExpressLayout Control Q434679 - A layout group fires the OnTabChanging event twice if the event's handler calls Application.ProcessMessages Q433283 - A layout group with a label layout item that is set to occupy the entire client area of its group has an incorrect width B218895 - Documentation - Incorrect topic navigation due to a corrupt HLP file (Delphi 7 only) ExpressPrinting System Q440760 - Export to PDF - The File Save dialog is not shown if the default file name for a report is too long B218629 - In the Page Number Format dialog, the "Start At" field value is incorrectly validated for character-based number formats B218627 - TBasedxReportLink descendants - Customized values of the TimeFormat, DateFormat and PageFormat properties are reset to their default values in some cases if default formats have been customized at the TdxComponentPrinter level Q440453 - TdxComponentPrinter - The Date And Time dialog cannot be re-opened after the last time format has been selected in the Available Time Formats list Q435027 - The Print Preview window freezes when invoked from a window located in a DLL file B219022 - TreeList Report Link - Rich text formatting is missing when printing cxRichEdit columns ExpressQuantumGrid Suite Q404033 - An exception is thrown when the selection is modified within the View's OnSelectionChanged event handler Q430561 - Assigning a Table View column to a Layout View data item or Card View row modifies the assignee's GroupIndex property Q434910 - Compilation errors occur after the View's Navigator.InfoPanel.OnClick event handler has been created at design time due to the missing cxNavigator unit in the 'uses' clause Q437880 - Data-aware Views - The "RecordIndex out of range" exception is thrown when removing a record if the View contains unbound columns Q433982 - Data-aware Views - The "RowIndex out of range" exception is thrown when updating the TClientDataSet bound to the View within a form's OnDestroy event handler using EmptyDataSet, etc. B218884 - Layout View - Card captions and currently focused items are incorrectly painted in selected cards B218883 - Layout View - Cell content areas are hot-tracked regardless of the View's OptionsBehavior.ItemHotTrack property value B218885 - Layout View - The text color specified in the View's Styles.OnGetItemStyle event handler is not applied to card layout items Q438267 - Server Mode - Clicking a Filter Row cell in a column containing Null values throws the "Could not convert variant of type (Null) into type (OleStr)" exception Q435475 - Tabular and Layout Views - The View does not synchronize edit value changes with the data controller in the OnEditChanged event handler if DataController.Options includes dcoImmediatePost, and a grid item's Properties.ImmediatePost property is set to True ExpressQuantumTreeList Suite Q434260 - TcxDBTreeList refreshes all data if a bound dataset was edited via the TreeList control when the OptionsData.SmartRefresh property is set to True Q435693 - TcxTreeList - An AV occurs when adding nodes in RAD Studio XE3 at design time ExpressScheduler Suite Q431232 - cxDateNavigator - The date navigator does not maintain the number of selected weeks always visible on screen when scrolling months backwards Q433746 - Day View - Resizing an event that lasts more than one day past 11:59pm increases the event's duration by one day if the ShowAllDayEventsInContentArea property is set to True ExpressSkins Library Q435604 - TdxBevel - Additional colors are not defined for the control in the Blueprint, DevExpressStyle, Seven, SevenClassic, VS2010, and Whiteprint skins Q436337 - The Skin Editor does not generate skin packages for RAD Studio XE3 ExpressSpreadSheet B218380 - The TcxSSViewInfoData record fields in the cxSSViewInfo.hpp file generated by a C++Builder application have an invalid alignment ExpressTile Control Q432087 - cxDateEdit controls are not displayed on a detail page when activating this page for the second and subsequent times in Windows XP B218389 - Focus does not move to the previous/next row when it passes the first/last tile within the current row if a tile control's OptionsBehavior.FocusItemOnCycle property is set to True ExpressVerticalGrid Suite Q439250 - Closing the Customization form does not disable the customization mode in error Common Libraries ExpressEditors Library Q431767 - TdxDBBreadcrumbEdit does not update its content after a new record is inserted into a database table in XE2 Update 4 Q434043 - Background and text colors are not applied to a read-only editor if its Properties.ReadOnly property is set via RepositoryItem Q434045 - cxMemo - Scrollbars are not shown if the editor is the last object in a DFM file, the editor has no text, and its Properties.ScrollBars property is set to ssBoth at design time B218869 - dxBreadCrumbEdit - A node's DeleteChildren method does not update the node's HasChildren property Q437728 - dxBreadcrumbEdit - An AV occurs when clicking the Root in a node's drop-down window when the selected node's children are repopulated within an OnPathSelect event handler B213307 - ExpressEditors are erroneously painted by VCL styles, as if they are standard VCL editors Q436036 - Some editors discard changes to the edit value if these changes were made by pasting data from the clipboard, using the Backspace key, etc. Q433948 - TcxImage - Intersections with other transparent DevExpress editors may appear distorted Q440954 - TcxScrollBox - The Create method does not use the GetViewInfoClass method Q436691 - TcxShellBrowserDialog - Memory leaks when selecting a file or folder in the dialog and clicking the OK button Q432788 - TcxSplitter - In Delphi 2010 and later, changes to the AlignSplitter property erroneously cause form resizing Q434498 - TdxShellBreadcrumbEdit - An AV occurs when selecting a file in a linked shell tree view B218303 - TdxShellBreadcrumbEdit - Files selected in a linked shell tree view are added as nodes (folders) to the breadcrumb editor ExpressLibrary Q432285 - TdxScreenTip - An AV occurs when displaying hints for ExpressQuantumGrid cells after ScreenTips have been shown by hint controllers located on other forms
data too long for column ‘name‘ at row 1的解决办法
会写Bug的攻城狮
10-17 1万+
产生这个问题的原因是：mysql乱码。产生乱码的根源在于编码解码使用不同的码表。 把数据库或者表的字符编码集改为GBK即可
Data too long for column ‘表名’ at row 1的若干解决方案（mysql编码转换的问题、中文乱码）
adi_1987的博客
12-05 5298
有经常使用表单进行传递字符串到数据库的经验的朋友可能会遇到这样一个问题：数据库获取到前台页面显示都是正常的（不是乱码），但是当使用表单传递值到执行页面插入到数据库的时候会出现无法插入，一般有如下提示：Data too long for column ‘表名’ at row 1 的提示，或者成功插入，但是显示出来中文是乱码。如果出现以上情况，，可以使用以下方法： 1、在连接数据库的代码处加上m
data too long for column 'name' at row 1的解决办法
A2268320026的专栏
02-03 2万+
产生这个问题的原因是：mysql乱码。产生乱码的根源在于编码解码使用不同的码表。 解决乱码方法,使用如下指令：set names gbk; 乱码原理解释： 第一条红线解释：控制台相当于客户端，数据库服务器认为客户端采取utf-8编码方式； 第二条红线解释：服务器认为客户端与服务器连接时，采取utf-8方式传送数据； 第三条红线j解释：服务器将数据返回时，以utf-8方式返回； 然而
MySQL插入中文时出现ERROR 1406 (22001): Data too long for column 'name' at row 1
mydeman的学习日志
06-25 2万+
      使用命令行方式登陆到MySQL服务器， 建立一个数据库，数据库编码设为UTF-8。此时，如果直接在命令行窗口使用insert语句插入中文，就遇到类似 ERROR 1406 (22001): Data too long for column name at row 1 错误。乍一看，是字段长度引起的问题，但是实际是字符编码的问题。可是尝试以下解决方法：      1、在Linux中，
ERROR 1406 : Data too long for column 解决办法
01-19
解决办法: 在my.ini里找到 sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_Create_USER,NO_ENGINE_SUBSTITUTION” 把其中的STRICT_TRANS_TABLES,去掉, 或者把sql-mode=STRICT_TRANS_TABLES,NO_AUTO_Create_USER,NO_ENGINE_SUBSTITUTION 注释掉，然后重启mysql就ok了
实验1答案 - 建立学生数据库.sql
09-21
建立环境实验和数据库/表 实验学时：2学时 实验类型：验证 实验要求：必修 一、实验目的 通过本实验的学习，使学生熟悉SQL Server 2014的集成环境，帮助学生掌握数据库、表的建立方法以及SQL Server的数据导入方法 二、实验内容    (一)、SQL Server 2014的安装 SQL Server2014的安装过程与 SQL Server 2008、SQL Server2012的安装过程类似，都提供了一个功能树以用来安装所有 SQL Server 组件，包括计划、安装、维护、工具、资源、高级、选项等功能。下面是各功能选项中所包含的内容，如图3-1所示。 图3-1 安装计划中的内容 （1）选择“安装”功能，因为要创建SQL Server 2014的全新安装，单击“全新SQL Server 2014独立安装或向现有安装添加功能”选项，如图3-2所示。 图3-2 “安装”功能中的内容 （2）在“产品密匙”页上，选择相应的单选按钮，这些按钮指示是安装免费版本的SQL Server还是具有产品密匙的产品版本，如果使指免费的评估版，只有180天的试用期限，如图3-3所示。 图3-3 “产品密钥”界面 （3）在“许可条款”页上阅读许可协议，然后选中相应的复选框以接受许可条款和条件。如图3-4所示。 图3-4 “许可条款”界面 （4）系统进行安装程序支持规则检查，以确定安装SQL Server安装程序支持文件时可能发生的问题。必须更正所有的失败，安装程序才能继续。如图3-5所示。 图3-5 “安装规则”界面 （5）在“设置角色”页上选择SQL Server功能安装，如图3-6所示。 图3-6 “设置”角色界面 （6）在“功能选择”页上选择要安装的组件。选择功能名称后，右侧窗体中会显示每个组件的说明。可以根据实际需要，选中一些功能，如图3-7所示。一般应用可选择“数据库引擎服务”、“客户端工具连接”、“SQL客户端连接”和“管理工具”等选项。 图3-7“功能选择”界面 （7）在“实例配置”页上制定是安装默认实例还是命名实例，对于默认实例，实例的名称和ID都是MSSQLSERVER，也可以自己“命名实例”安装实例，如图3-8所示。SQL Server支持多个实例，即支持在同一台计算机上同时运行多个SQL Server数据库引擎实例，每个SQL Server数据库引擎实例各有一套不为其它实例共享的系统及用户数据库。应用程序连接同一台计算机上的SQL Server数据库引擎实例的方式与连接其它计算机上运行的SQL Server数据库引擎的方式基本相同。 图3-8 “实例配置”界面 （8）在“服务器配置”页上指定SQL Server服务的登录帐户。SQL Server提供了多种服务，可以为所有SQL Server服务分配相同的登录账户，也可以分别配置每个服务账户。还可以指定服务是自动启动、手动启动还是禁用。Microsoft建议对各服务账户进行单独配置，以便为每项服务提供最低特权，即向SQL Server服务授予它们完成各自任务所需的最低权限，如图3-9所示。SQL Server中的每个服务代表一个进程或一组进程，每个进程需要有访问SQL Server相关文件和系统注册表的权限，为了能让SQL Server服务在操作系统中正常的启动和运行，就需要指定SQL Server的服务帐户，所以服务帐户指的是Windows操作系统中的帐户。 图3-9 “服务器配置”界面 （9）在“数据库引擎配置”的“服务器配置”页上指定身份验证模式、用户名、密码，如图3-10所示。这里的用户身份验证指的是登录到服务器使用的身份验证模式及用户名和密码。身份验证模式分为“Windows身份验证模式”和“混合模式（SQL Server身份验证和Windows身份验证）”。如果选择“Windows身份验证模式”表示则只能使用Windows的帐号登录，即使用当前登录到操作系统的帐号进行登录，通过这种方式用户登录到SQL Server中时不再需要输入帐号和密码。如选择“混合模式（SQL Server身份验证和Windows身份验证）”表示除了可以用使用登录到Windows的帐号作为登录的依据外，还可以使用SQL Server系统的帐号登录，这里必须为内置SQL Server系统管理员账户（SA）提供一个强密码。必须至少为SQL Server实例指定一个系统管理员。若要添加用以运行SQL Server安装程序账户，则要单击“添加当前用户”按钮。若要向系统管理员列表中添加账户或从中删除账户，则单击“添加…”或“删除…”按钮，然后编辑将拥有SQL Server实例的管理员特权的用户、组或计算机列表。 图3-10 设置身份验证模式和管理员 （10）在“准备安装”页显示安装过程中的安装选项的树视图，如图3-11所示。若要继续，单击“安装”按钮。在安装过程中，“安装进度”页会提供相应的状态，因此可以在安装过程中监视安装进度。 图3-121“准备安装”界面 （11）安装完成后，“完成”页提供指向安装日志文件摘要以及其他重要说明的链接。如图3-12所示。 图3-12 “安装完成”界面 (二)、建库建表练习      1、利用语句建库和建表： 创建学生数据库StuDB，文件名和位置自定，在此数据库中创建如下三张表： 学生表(student) (   学号(sno) 普通编码定长字符类型，长度9，主码，   姓名(sname) 普通编码定长字符类型，长度10，非空，   性别(ssex) 统一编码定长字符类型，长度2，   年龄(sage) 微整型，   所在系(sdept) 统一编码可变长字符类型，长度20 ） 课程表(course) (   课程号(cno) ，通编码定长字符类型，长度4，主码，   课程名(cname) 统一编码定长字符类型，长度,40，非空，   开课学期(Semester) 短整数， 学分(credit) 短整数 ） 修课表（sc）(   学号(sno) 普通编码定长字符类型，长度7，主码，外码   课程号(cno) 普通编码定长字符类型，长度6，主码，外码   成绩(grade) 小整型，   修课类别（ctype）普通编码定长字符类型，长度4 ） 2、建立“汽车”数据库，文件名和位置自定，在此数据库中创建如下三张表： 汽车表（CarT），结构如下：   汽车序号（CId） 整型 主关键字，   汽车名称（CName） 普通编码定长字符类型 长度为10  非空，   型号（CType）普通编码变长字符类型 长度为60  非空，   价格（CPrice） 整型，   车身眼色（Ccolor）普通编码变长字符类型 长度为20。 部门表（DepartT），结构如下：   部门序号（DId）整型 主关键字，   部门名（DName）普通编码定长字符类型 长度为20   非空，   负责人名（DLead）普通编码定长字符类型 长度为10  非空，   人数（DAmount） 整型。 汽车出厂表（FacT），结构如下：   汽车序号（CID） 整型 非空，   部门序号（DId） 整型 非空，   出厂日期（FDate）小日期时间型 非空，   出厂数量（FAmount） 整型，   出厂价格（FPrice） 整型。   其中：主关键字为（汽车序号，部门序号，出厂日期）   “汽车序号”为引用汽车表的“汽车序号”的外部关键字； “部门序号”为引用部门表的“部门序号”的外部关键字。 3、使用数据库的可视化工具建库建表 建立银行贷款表，具体要求同课堂教学的建库建表一致。 银行表（BankT）（ 银行代码（Bno） 主键 银行名称（Bname） 非空 电话（Tel） ） 法人表（LET）（ 法人代码（Eno）主键 法人名称（Ename）取值唯一 经济性质（Enature） 注册资金（Ecapital） 法定代表人（Erep） ） 贷款表（LoanT）( 法人代码（Eno） 银行代码（Bno） 贷款日期（Ldata） 贷款金额（Lamount） 贷款期限（Lterm） ）        (三)、数据导入练习 将“学生数据库数据.xls”中的数据导入到学生数据库的三张表中。 将“银行贷款数据.xls”中的数据导入到银行贷款数据库的三张表中。 三、实验报告 将实验结果反映在实验报告中，并对实验中遇到的问题及解决方案、进行整理、分析总结，提出实验结论或自己的看法。
mysql 1406文本_mysql报错：“1406, Data too long for column”
weixin_39643336的博客
01-27 919
mysql存储的时候报错：pymysql.err.DataError: (1406, "Data too long for column 'songlist_url' at row 1")查看网上资料有说因为数据库中设置的字符长度不够，我加长了以后依然会报错。另一种说法是由于输入了中文，编码出现了问题。查看MySQL的status;，发现：Server characterset: latin...
【收藏】MySQL出现data too long for column ‘name‘ at row 1 解决
学亮编程手记
08-02 1409
https://www.linuxidc.com/Linux/2016-02/128315.htm （1）set names gbk;（只对当前窗口有效） （2）找到MySQL的安装目录，把文件my.ini里的“default-character-set=utf8”修改为“default-character-set=gbk”，然后重启mysql服务 ...
Data too long for column ‘xxxx‘ at row 1 解决办法
qq_34565436的博客
11-11 3万+
问题现象描述 Data too long for column 'xxxx' at row 1 1、第一种情况就是很普遍的，xxx字段长度不够 在数据库中修改表结构 将该字段长度改大一些，再或者将类型改大写，比如varchar -------->text；text ------->longtext；之后再尝试下是否能成功保存到数据库； 2、就是用Mybatis映射文件xml，字段匹配顺序错误即 原来很短的一个列，插入了很长的数据 insert into xxxx(column1,
成功解决data too long for column 'name' at row 1
热门推荐
zhaopeipei1985的专栏
07-10 19万+
在程序中写了一段代码向数据库中插入数据，出现了data too long for column name at row 1的问题。在google搜了一下解决方法，真是五花八门，也逐一试了一遍，终于终于将问题解决了。下面先贴一下网上的众多解决1、修改my.ini文件：将sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE
mysql 中文 too long_mysql解决中文乱码，插入中文错误，Data too long for column 'name' at row 1...
weixin_30821881的博客
01-19 671
1、在导入数据前执行以下命令即可：set SESSION sql_mode='';2、附上一个简单的sql测试代码：#drop database test_001;create database test_001 default character set utf8 collate utf8_general_ci;use test_001;create table config (id...
c# mysql 加锁解锁
最新发布
photon222的博客
05-21 80
然后使用LOCK TABLES语句对mytable进行写操作锁定，这将阻止其他事务对该表进行写操作。在完成了需要执行的业务逻辑之后，使用UNLOCK TABLES解锁表，并提交事务。在C#中操作MySQL实现加锁和解锁，通常是通过执行特定的SQL语句来完成。MySQL支持表级锁定和行级锁定。请注意，行级锁定通常是通过在SELECT语句中使用FOR UPDATE子句来实现的，这通常在事务中进行处理。务必确保在使用事务和锁定的时候遵循最佳实践，例如尽可能减少锁定的时间和范围，以避免阻塞其他数据库操作。
Data truncation: Data too long for column 'name' at row 1
09-06
引用和显示，问题是由于列'name'的数据太长而导致的。这个错误消息意味着在第1行的'name'列的数据超出了该列的最大长度限制。引用中提到，该列在表goods_category中存在，预留的存储长度不够导致内容过长。解决这个问题的方法是要么缩短数据长度，要么增加'name'列的存储长度。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *3* [【异常】MySQL提示MysqlDataTruncation: Data truncation: Data too long for column ‘name‘ at row 1](https://blog.csdn.net/wstever/article/details/129160700)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* [com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘name‘ at row](https://blog.csdn.net/u014150715/article/details/107330742)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值